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