> The 3636 INSERT-Statements contains a fix value for the ID-Column,
> right? Thats wrong, omit the id-column and value or use simply 'default' for it.
That's right. I thought that might be the case.
> > - how can I rectify the situation?
> Set the sequence to the new value, 3636+9, via
> setval('your_sequence', 3636+9)
I'll re-import the data with DEFAULT in the id (SERIAL) column, hopefully new inserts will be OK then and I can leave the sequence alone?
Thanks
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
