Message-ID: <419B63E3.5040900@archonet.com>
Date: Wed, 17 Nov 2004 14:44:51 +0000
From: Richard Huxton <dev@archonet.com>
User-Agent: Mozilla Thunderbird 0.9 (X11/20041103)
MIME-Version: 1.0
To: Achilleus Mantzios <achill@matrix.gatewaynet.com>
Cc: abief_ag_-postgresql@yahoo.com, pgsql-sql@postgresql.org
Subject: Re: session_id
References: <Pine.LNX.4.44.0411171629170.8373-100000@matrix.gatewaynet.com>
In-Reply-To: <Pine.LNX.4.44.0411171629170.8373-100000@matrix.gatewaynet.com>
Content-Type: text/plain; charset=ISO-8859-7; format=flowed
Content-Transfer-Encoding: 8bit

Achilleus Mantzios wrote:
> O Richard Huxton έγραψε στις Nov 17, 2004 :
> 
> 
>>Riccardo G. Facchini wrote:
>>
>>>hi all,
>>>
>>>is there a way to determine the session id on a database session?
>>>
>>>I would need to have a unique number whenever a session is started, and
>>>have this available as a function or view result.
> 
> 
> Why not SELECT pg_backend_pid();
> ??

This is guaranteed to be unique while connected, but if you want to 
track sessions over time isn't guaranteed to be. So, if you might have 
pid=1234 now and also a month ago in a different session (especially if 
you had a server reboot in-between).

Of course, if Riccardo doesn't need that, the pid is fine.

--
   Richard Huxton
   Archonet Ltd