Re: How do you detect row version changes in PostgreSQL?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: How do you detect row version changes in PostgreSQL?
Дата
Msg-id 1395.967557851@sss.pgh.pa.us
обсуждение исходный текст
Ответ на How do you detect row version changes in PostgreSQL?  ("Craig Manley" <bitneuker666@hotmail.com>)
Список pgsql-sql
"Craig Manley" <bitneuker666@hotmail.com> writes:
> Some databases have a hidden field that contains a row version key.
> Everytime an update is performed on a row the value of the version field
> changes. Does PostgreSQL have a similar hidden field?

See xmin (and also cmin if you need to keep track of multiple changes
intra-transaction).  It might not be defined quite the way you want,
but if you're not picky about what a "version number" is, it'll do.
        regards, tom lane


В списке pgsql-sql по дате отправления:

Предыдущее
От: hlefebvre
Дата:
Сообщение: Re: Re: Argument variables for select
Следующее
От: Tom Lane
Дата:
Сообщение: Re: performance on insert/update