Re: [GENERAL] Is the row version available in SQL?

Поиск
Список
Период
Сортировка
От Rob Nikander
Тема Re: [GENERAL] Is the row version available in SQL?
Дата
Msg-id C57CD696-156B-4A2B-9D97-16E603A795D3@gmail.com
обсуждение исходный текст
Ответ на Re: [GENERAL] Is the row version available in SQL?  (Chris Travers <chris.travers@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Timokhin Maxim
Дата:
Сообщение: [GENERAL] duplicate key value violates unique constraint and duplicated records
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: [GENERAL] 9.6 parameters messing up my 9.2 pg_dump/pg_restore