Re: Migration problem - serial fields - Mailing list pgsql-general

rick@planetdigital.com (Rick) writes:
> Obviously my transfer did not update the sequence used by the serial
> field -- it's still stuck at 1.  However, I'm just not sure of the
> best course of action.

No, it wouldn't.  After you transfer the data, advance the sequence
with something like

SELECT setval('seqname', (SELECT max(serialcol) FROM table));

and then you're good to go.

            regards, tom lane