On Thu, Jan 26, 2006 at 05:05:19PM -0500, Eric B. Ridge wrote:
> I really need a way to create a unique identifier at the start of a
> top-level transaction, and be able to use it via triggers and/or
> column default values in that or its subtransactions.
I suppose a sequence is out of the question? Too easy to get it
wrong?
> Is there some kind of "TopXID" magic variable/function that I haven't
> found in the documentation?
Not in the standard installation, but I think a C function that
returns GetTopTransactionId() should work. It's trivial to write
and examples have been posted before; search the archives.
--
Michael Fuhr
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
