On Wed, Nov 16, 2011 at 07:08:27PM -0500, Tom Lane wrote:
I wrote:
Simon Riggs si...@2ndquadrant.com writes:
We need a function called transactionid_current() so a normal user can
write
select virtualtransaction
from pg_locks
where transactionid = transactionid_current()
and
I wrote:
Simon Riggs si...@2ndquadrant.com writes:
We need a function called transactionid_current() so a normal user can write
select virtualtransaction
from pg_locks
where transactionid = transactionid_current()
and have it just work.
That would solve that one specific use-case. The
On Sun, Nov 13, 2011 at 11:16 PM, Tom Lane t...@sss.pgh.pa.us wrote:
While investigating bug #6291 I was somewhat surprised to discover
$SUBJECT. The cause turns out to be this kluge in alter_table.sql:
select virtualtransaction
from pg_locks
where transactionid =
Simon Riggs si...@2ndquadrant.com writes:
We need a function called transactionid_current() so a normal user can write
select virtualtransaction
from pg_locks
where transactionid = transactionid_current()
and have it just work.
That would solve that one specific
On Sun, Nov 13, 2011 at 6:16 PM, Tom Lane t...@sss.pgh.pa.us wrote:
While investigating bug #6291 I was somewhat surprised to discover
$SUBJECT. The cause turns out to be this kluge in alter_table.sql:
select virtualtransaction
from pg_locks
where transactionid =
While investigating bug #6291 I was somewhat surprised to discover
$SUBJECT. The cause turns out to be this kluge in alter_table.sql:
select virtualtransaction
from pg_locks
where transactionid = txid_current()::integer
which of course starts to fail with integer out of