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