On Jan 17, 2008 9:19 AM, James B. Byrne <byrnejb@xxxxxxxxxxxxx> wrote: > > On Thu, January 17, 2008 10:15, Scott Marlowe wrote: > > > > If race conditions are a possible issue, you use a sequence and > > increment that until you get a number that isn't used. That way two > > clients connecting at the same time can get different, available > > numbers. > > > > That is close to the idea that I originally had. I was simply wondering > if the built-in sequencer could handle this case or whether I need to roll > my own. Yeah, the built in sequencer just increments by one, nothing else. But it should be pretty easy to write a pl/pgsql function that grabs the next value and loop until it finds one that's available. ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org/