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.