| 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: | Whole Thread | Raw Message | 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
| 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 |