> On Jun 28, 2017, at 11:39 AM, Chris Travers <chris.travers@xxxxxxxxx> 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@xxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
