| From: | Andrew Dunstan <andrew(at)dunslane(dot)net> |
|---|---|
| To: | "Florian G(dot) Pflug" <fgp(at)phlo(dot)org> |
| Cc: | Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>, pgsql-patches(at)postgresql(dot)org, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Subject: | Re: Lazy xid assignment V4 |
| Date: | 2007-09-05 21:59:06 |
| Message-ID: | 46DF26AA.6010908@dunslane.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Florian G. Pflug | 2007-09-05 22:07:53 | Re: Lazy xid assignment V4 |
| Previous Message | Florian G. Pflug | 2007-09-05 21:49:58 | Re: Lazy xid assignment V4 |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2007-09-05 22:07:21 | Re: HOT patch - version 15 |
| Previous Message | Florian G. Pflug | 2007-09-05 21:49:58 | Re: Lazy xid assignment V4 |