rick(at)planetdigital(dot)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