Re: rows modified in current transaction

On Thu, Aug 30, 2012 at 10:36 AM, Miroslav Šimulčík
<simulcik.miro@gmail.com> wrote:
> is there any way to check if row have already been modified by the current
> transaction? I tried condition txid_current() = xmin, but there is problem
> with the savepoints. After every savepoint rows are getting higher xmin
> values, but txid_current() remains the same.

It sounds like you're looking for a function that will give an array
of all XIDs for the current transcation, rather than just the XID of
the current sub-transaction.  I don't think we currently expose that.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company