Re: rows modified in current transaction

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: Miroslav Šimulčík <simulcik(dot)miro(at)gmail(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: rows modified in current transaction
Date: 2012-08-30 16:06:59
Message-ID: CA+TgmobA+hu_QOGG9Uqg1+t82CSSCmhnkMQHkzVmWJu3RvAotw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Thu, Aug 30, 2012 at 10:36 AM, Miroslav Šimulčík
<simulcik(dot)miro(at)gmail(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andres Freund 2012-08-30 16:09:43 Re: rows modified in current transaction
Previous Message Robert Haas 2012-08-30 16:02:27 Re: PATCH: pgbench - aggregation of info written into log