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.
How about
select procpid||' '||backend_start from
Rodrigo De Leon wrote:
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.
How about
select procpid||'
That's pretty roundabout. We already expose (hex coded) pid.starttime as
a session identifier in log_line_prefix (it's the %c escape) so I don't
see any reason not to provide either the same thing directly in a
function, or at least to expose the backend pid.
That would be nice.
Andrew Dunstan [EMAIL PROTECTED] writes:
Rodrigo De Leon wrote:
You could do this:
SELECT procpid||' '||backend_start
FROM pg_stat_activity
WHERE datname = current_database()
AND usename = session_user
AND client_addr = inet_client_addr()
AND client_port = inet_client_port();
That's
It seems MyProcID is what I was searching for...
David Hoksza
DH Something like this would be maybe possible, but this select can
DH return more rows, when the user is connected with more instances...
DH David Hoksza
DH
Hi, I
Hannu Krosing said:
Ãhel kenal päeval, N, 2006-06-01 kell 10:10, kirjutas David Hoksza:
It seems MyProcID is what I was searching for...
On a buzy server with lots of connects, procID will repeat quite often.
log_line-prefix has a sessionid gadget:
Session ID: A unique identifier for
Something like this would be maybe possible, but this select can
return more rows, when the user is connected with more instances...
David Hoksza
Hi, I cant find any function, which tells me something like session
id. Is there something like that? I need it in
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.
And second thing - it would be great if I could save pointer in