Something like this would be maybe possible, but this select can
return more rows, when the user is connected with more instances...
>> Hi, I cant find any function, which tells me something like session
>> id. Is there something like that? I need it in my AM, because I need
>> to know, if something which I wrote in file was written in this
>> current session or previously.
AL> How about
AL> select procpid||' '||backend_start from pg_stat_activity;
AL> Laurenz Albe
pgsql-hackers by date
|Next:||From: Andrew Dunstan||Date: 2006-06-01 00:27:24|
|Subject: Re: server crash on recursive function invocation|
|Previous:||From: Tom Lane||Date: 2006-05-31 22:02:52|
|Subject: Re: [HACKERS] psql \copy warning |