Re: [GENERAL] Unique Session ID in PGSQL?

2011-05-19 Thread Merlin Moncure
On Thu, May 19, 2011 at 4:21 AM, Albe Laurenz wrote: > Pavel Stehule wrote: >>> Is there any function in PGSQL that returns an unique Session >>> identifier of the actual session? >>> For example a Bigint, or GUID, or etc? >>> Can I get the living Session identifiers from PG? >> >> try >> >> postg

Re: [GENERAL] Unique Session ID in PGSQL?

2011-05-19 Thread Albe Laurenz
Pavel Stehule wrote: >> Is there any function in PGSQL that returns an unique Session >> identifier of the actual session? >> For example a Bigint, or GUID, or etc? >> Can I get the living Session identifiers from PG? > > try > > postgres=# select pg_backend_pid(); > pg_backend_pid > -

Re: [GENERAL] Unique Session ID in PGSQL?

2011-05-18 Thread Pavel Stehule
Hello 2011/5/18 Durumdara : > Hi! > > Is there any function in PGSQL that returns an unique Session > identifier of the actual session? > For example a Bigint, or GUID, or etc? > Can I get the living Session identifiers from PG? try postgres=# select pg_backend_pid(); pg_backend_pid ---

[GENERAL] Unique Session ID in PGSQL?

2011-05-18 Thread Durumdara
Hi! Is there any function in PGSQL that returns an unique Session identifier of the actual session? For example a Bigint, or GUID, or etc? Can I get the living Session identifiers from PG? We have a little application that uses these infos which are basically came from another database system, an