On Fri, Oct 08, 2004 at 03:00:07 -0700,
Miles Keaton <[EMAIL PROTECTED]> 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.
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
