On Nov 10, 2008, at 6:48 PM, Brent Wood wrote:
Hi,
I have a number of tables with serial columns as a primary key.
I'm looking to add lots of records via copy, but should reset the
serial counters to the appropriate value after this.
Is there a simple way to do this, or do I just update the last_value
column in each seq table to the max(id) from the relevant table.
You shouldn't edit sequence table directly. To set a sequence's value
you should use the setval(seqname, seqval) function like so:
SELECT setval('some_seq', 1000);
Erik Jones, Database Administrator
Engine Yard
Support, Scalability, Reliability
866.518.9273 x 260
Location: US/Pacific
IRC: mage2k
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
