Re: [SQL] Getting current transaction id

2002-09-25 Thread Michael Paesold
Tom Lane wrote: > Michael Paesold <[EMAIL PROTECTED]> writes: [snip] > > If it's not working I will have to implement my own transactions table. > > That's what I'd recommend. Transaction IDs are internal to the database > and are not designed for users to rely on. > > regards, tom lane Well

Re: [SQL] Getting current transaction id

2002-09-25 Thread Tom Lane
Michael Paesold <[EMAIL PROTECTED]> writes: > I just read it's possible to get the MVCC last version numbers. Is it also > possible to get the current transaction id? Well, there's the brute force way: insert a tuple in some table and look at its xmin. Offhand I don't think we provide a SQL func

[SQL] Getting current transaction id

2002-09-23 Thread Michael Paesold
Hi all, I just read it's possible to get the MVCC last version numbers. Is it also possible to get the current transaction id? Would it be possible to check later if that transaction has been commited? This would be nice for a distributed application to enforce an "exactly once" semantics for tra