Bruce Momjian <[EMAIL PROTECTED]> writes:
> Andrew Dunstan wrote:
>> Bruce and others have suggested that PID is not sufficiently unique.
 
> The nice things about using xid for session id is that is is unique for
> a long time, rather than pid.

Hmm.  Now that I think about it, InitPostgres() always runs a
transaction during backend startup.  If we simply saved aside the XID
assigned to that transaction, it would cost next to nothing to do and
would provide a reasonably unique ID.  However, this happens much later
than the postmaster currently prints the log_connection message ...

                        regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

               http://archives.postgresql.org

Reply via email to