On Fri, Oct 08, 2004 at 03:00:07 -0700,
Miles Keaton <mileskeaton(at)gmail(dot)com> wrote:
> I thought Postgres would be smart enough to make the clients_id_seq
> skip existing numbers, but I guess not!
It wouldn't be very efficient to do that.
> Do I, instead, have to be smart enough to set the sequence over the
> highest existing id# from my imported data, so that it can blindly
> increment without clashing?
That is normally what you want to do.
> If so, setval() would be best for that, right?
Yes.