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.