Re: Getting rows in statement-level triggers - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: Getting rows in statement-level triggers
Date
Msg-id 20081003160605.GA3817@alvh.no-ip.org
Whole thread Raw
In response to Re: Getting rows in statement-level triggers  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tom Lane wrote:

> The traditional way to find out your own XID is to insert a dummy row
> somewhere (perhaps in a temp table) and see what its xmin is.  I'm not
> sure why we don't expose a more convenient way --- maybe just that
> there's not been any demand for it.

I think we've suggested the trick of checking the xmin of some row
enough times that a better way to access it is warranted.  There's
certainly been more demand than "not any".

--
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

pgsql-general by date:

Previous
From: "Rob Richardson"
Date:
Subject: Re: How do I save data and then raise an exception?
Next
From: Blazej
Date:
Subject: Re: How do I save data and then raise an exception?