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
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
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