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.