[HACKERS] rows modified in current transaction

2012-08-30 Thread Miroslav Šimulčík
Hi, 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. Regards, Miroslav

Re: [HACKERS] rows modified in current transaction

2012-08-30 Thread Robert Haas
On Thu, Aug 30, 2012 at 10:36 AM, Miroslav Šimulčík simulcik.m...@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

Re: [HACKERS] rows modified in current transaction

2012-08-30 Thread Andres Freund
On Thursday, August 30, 2012 06:06:59 PM Robert Haas wrote: On Thu, Aug 30, 2012 at 10:36 AM, Miroslav Šimulčík simulcik.m...@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

Re: [HACKERS] rows modified in current transaction

2012-08-30 Thread Tom Lane
Robert Haas robertmh...@gmail.com writes: On Thu, Aug 30, 2012 at 10:36 AM, Miroslav Šimulčík simulcik.m...@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

Re: [HACKERS] rows modified in current transaction

2012-08-30 Thread Andres Freund
On Thursday, August 30, 2012 06:09:43 PM Andres Freund wrote: On Thursday, August 30, 2012 06:06:59 PM Robert Haas wrote: On Thu, Aug 30, 2012 at 10:36 AM, Miroslav Šimulčík simulcik.m...@gmail.com wrote: is there any way to check if row have already been modified by the current