> Are you > sure that the sequence is being used to insert those values into the > table?
When I insert a new row into either of the tables I previously described, the sequence 'Current value' increments by one. When I use pg_dump to backup the database most of the setval() calls in my SQL file have a '1', like this: SELECT pg_catalog.setval('company_id_seq', 1, false); Some do not have a '1', some are actually set correctly. Thanks. -- Greg Donald -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general