how to best resync serial columns - Mailing list pgsql-general

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
relevanttable.  


Thanks,

   Brent Wood

Brent Wood
DBA/GIS consultant
NIWA, Wellington
New Zealand
NIWA is the trading name of the National Institute of Water & Atmospheric Research Ltd.