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
Greg Peters wrote:
CSG=# \d admin_field_list
Table "public.admin_field_list"
Column|Type |
Modifiers
-+-+
key | big
ERROR: duplicate key violates unique constraint "admin_field_list_pkey"
CSG=#
/I don't understand what is going on. It seems that it can't increment
the primary key properly, or for some reason it's trying to assign an
incorrect value to the key column. If i change the command to include a
va
*Hello all, *
**
*I have a small problem I hope somebody can help with.*
**
*I have a table with the following definition:*
CSG=# \d admin_field_list
Table "public.admin_field_list"
Column|Type |
Modifiers
-+-
