On Mon, 08 Nov 2004 13:07:34 -0500 Tom Lane <[EMAIL PROTECTED]> wrote: > "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/).
Perhaps. I assume that the lock is automatically released when the holder closes its connection to the database, right? If so then that's what I need. -- D'Arcy J.M. Cain <[EMAIL PROTECTED]> | Democracy is three wolves http://www.druid.net/darcy/ | and a sheep voting on +1 416 425 1212 (DoD#0082) (eNTP) | what's for dinner. ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster