Re: Lazy xid assignment V4 - Mailing list pgsql-patches

From Andrew Dunstan
Subject Re: Lazy xid assignment V4
Date
Msg-id 46DF26AA.6010908@dunslane.net
Whole thread Raw
In response to Re: Lazy xid assignment V4  ("Florian G. Pflug" <fgp@phlo.org>)
Responses Re: Lazy xid assignment V4
Re: Lazy xid assignment V4
List pgsql-patches

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.
>
> Hm.. Maybe we should put that into the docs or into the release notes?
>
>

or make it a system view?

cheers

andrew

pgsql-patches by date:

Previous
From: "Florian G. Pflug"
Date:
Subject: Re: Lazy xid assignment V4
Next
From: Bruce Momjian
Date:
Subject: Re: HOT patch - version 15