> jtv@xs4all.nl writes:
> pg_locks certainly seems like a better solution. Perhaps it didn't
> exist when you went with pg_stat_activity? Can't recall offhand.
Neither do I... But I do need something that will work with at least any
recent backend version--say, 7.2 or since. The more the better, really.
Any idea how old pg_locks is?
> Note that you still want to look for your old backend's PID; it seems
> impractically expensive to keep track of the current transaction's XID.
> (At a minimum that would cost another query per xact...)
Yes, I see now--I thought I had the transaction ID handy already anyway,
but I didn't. Thanks.
Jeroen