[GENERAL] Problem with unique key

2006-11-28 Thread Greg Peters
data currently in the table:* ** CSG=# select * from admin_field_list; key | field | added_by |add_date | mod_date | modified_by -+--+-+-----+--+- 1 | Talinga | Greg Peters | 2006-08-28 22:14:

Re: [GENERAL] Problem with unique key

2006-11-28 Thread Greg Peters
Thanks all, with your help I figured out what happened. You are all correct in that the sequence is out of sync with the "key" value. I dumped the db and then selectively restored it from the sql file some time ago by cutting and pasting directly to the command prompt. I must have left out the co