Re: [GENERAL] Is the row version available in SQL? - Mailing list pgsql-general

From Rob Nikander
Subject Re: [GENERAL] Is the row version available in SQL?
Date
Msg-id C57CD696-156B-4A2B-9D97-16E603A795D3@gmail.com
Whole thread Raw
In response to Re: [GENERAL] Is the row version available in SQL?  (Chris Travers <chris.travers@gmail.com>)
List pgsql-general
> On Jun 28, 2017, at 11:39 AM, Chris Travers <chris.travers@gmail.com> wrote:
>
> For that, you could use xmin.  That tracks the transaction where the row first became visible.

> On Jun 28, 2017, at 4:34 PM, Merlin Moncure <mmoncure@gmail.com> wrote:
>
> What you are describing is called 'optimistic locking’.  […]
> https://blog.2ndquadrant.com/postgresql-anti-patterns-read-modify-write-cycles/


Thanks, both answers helped.

Rob



pgsql-general by date:

Previous
From: Timokhin Maxim
Date:
Subject: [GENERAL] duplicate key value violates unique constraint and duplicated records
Next
From: Adrian Klaver
Date:
Subject: Re: [GENERAL] 9.6 parameters messing up my 9.2 pg_dump/pg_restore