"D'Arcy J.M. Cain" <darcy(at)druid(dot)net> 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