Andrew Dunstan <andrew@dunslane.net> writes:
> Florian G. Pflug wrote:
>> So, in essence, you get the old pg_locks format back by doing
>> select l1.*, l2.transactionid as "transaction" from pg_locks l1,
>> pg_locks l2
>> where l1.vxid = l2.vxid and l2.locktype = 'transaction'
>> and l2.mode='exclusive' and l2.granted=true.
You'd want some sort of left join, no doubt, else you're not going to
see transactions that have not got an XID.
> or make it a system view?
That would be a bit silly. If there's actually still a use-case for the
XID column then we should just put it back. I don't actually see a
reasonable use-case for it though. As Florian points out, you can get
it if you really need it --- but that view is already annoyingly wide,
and I'm not eager to burden it with columns that are usually useless.
Also, I still agree with Florian's earlier argument that we should
deliberately break any code that's depending on the transaction column.
Any such code is unlikely to be prepared for the column containing nulls.
regards, tom lane
