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 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>> Yours, AL>> Laurenz Albe DH> ---------------------------(end of DH> broadcast)--------------------------- DH> TIP 5: don't forget to increase your free space map settings ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
