Re: [HACKERS] Timestamp field

Поиск
Список
Период
Сортировка
От Jose' Soares Da Silva
Тема Re: [HACKERS] Timestamp field
Дата
Msg-id Pine.LNX.3.96.980611105440.3123A-100000@proxy
обсуждение исходный текст
Ответ на Timestamp field  (Byron Nikolaidis <byronn@insightdist.com>)
Список pgsql-hackers
On Wed, 10 Jun 1998, Byron Nikolaidis wrote:

> Am I right in my thinking that Postgres does not have a pseudo timestamp
> field that is updated whenever a row is added or updated?   Did it used
> to have one before time travel was removed?
>
> If no timestamp field, are there any other pseudo fields that are
> updated every time?  I noticed that the 'ctid' field seems to qualify,
> but what does something like (1,54) mean?
>
> Thanks for any help.
>
> Byron

Seems that XMIN field is updated whenever a row is inserted or updated.
see man sql.
                                                            Jose'


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

Предыдущее
От: Peter Mount
Дата:
Сообщение: Re: FW: [HACKERS] now 6.4
Следующее
От: dg@illustra.com (David Gould)
Дата:
Сообщение: Re: [HACKERS] maximum of postgres ?