"D'Arcy J.M. Cain" <[EMAIL PROTECTED]> writes: > I checked the FAQ and docs but haven't found anything definitive. This > is my SQL test script:
> SELECT pg_backend_pid(); > SELECT * FROM pg_stat_activity order by procpid; > When I run psql reading that I find that my backend procpid is not in > the list. I know that I can see it if I can introduce a little sleep (1 > second) between the connection and the reading of pg_stat_activity. ISTM that what you have here is a bad substitute for using user locks (see contrib/userlock/). regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html