In my Contacts table i have a ContactsID field specified as a serial field.
If I add a record it increases the contactID by 1 as expected.
If I now delete the record and add another record the contactID increases by 2
Can this be avioded ?
Please note I am a novice