Re: Getting current transaction id

From: "Michael Paesold" <mpaesold(at)gmx(dot)at>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Getting current transaction id
Date: 2002-09-25 20:21:24
Message-ID: 02b701c264d1$1f3e6340$4201a8c0@beeblebrox
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers pgsql-sql

Tom Lane wrote:

> Michael Paesold <mpaesold(at)gmx(dot)at> 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, after reading your explanation I agree with you that it is better
to have my own transaction table. I appreciate your detailed response.

Thanks very much!

Best Regards,
Michael Paesold

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Patrick Welche 2002-09-25 20:26:10 Re: "lo" large object
Previous Message Tom Lane 2002-09-25 20:11:24 Re: "lo" large object

Browse pgsql-hackers by date

  From Date Subject
Next Message Patrick Welche 2002-09-25 20:30:15 Relation 0 does not exist
Previous Message Tom Lane 2002-09-25 20:14:26 Re: PGXLOG variable worthwhile?

Browse pgsql-sql by date

  From Date Subject
Next Message Ludwig Lim 2002-09-26 09:57:29 Tuning complicated query
Previous Message Philip Hallstrom 2002-09-25 20:19:39 Re: SQL formatter?