Andrew Dunstan wrote:
> Tom Lane said:
> > Andrew Dunstan <andrew@dunslane.net> 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 pgman@candle.pha.pa.us | (610)
359-1001+ If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square,
Pennsylvania19073