Andrew Dunstan wrote: > Tom Lane said: > > Andrew Dunstan <[EMAIL PROTECTED]> writes: > >> I'm not sure I understand. I didn't suggest that a sequence should be > >> used for txn ids. For the purpose I had in mind we would call > >> nextval() once per connection, > > > > Oh, okay, I misunderstood. But why not just use the PID? > > > > Bruce and others have suggested that PID is not sufficiently unique. > Personally, I can live with it :-) The nice things about using xid for session id is that is is unique for a long time, rather than pid.
-- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]