Re: Is the row version available in SQL?

From: Rob Nikander <rob(dot)nikander(at)gmail(dot)com>
To: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Is the row version available in SQL?
Date: 2017-06-29 11:09:09
Message-ID: C57CD696-156B-4A2B-9D97-16E603A795D3@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


> On Jun 28, 2017, at 11:39 AM, Chris Travers <chris(dot)travers(at)gmail(dot)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(at)gmail(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2017-06-29 12:49:20 Re: 9.6 parameters messing up my 9.2 pg_dump/pg_restore
Previous Message Timokhin Maxim 2017-06-29 09:28:59 duplicate key value violates unique constraint and duplicated records