Re: "xmin" system column

Поиск
Список
Период
Сортировка
От Michael Fuhr
Тема Re: "xmin" system column
Дата
Msg-id 20060126223025.GA98934@winnie.fuhr.org
обсуждение исходный текст
Ответ на Re: "xmin" system column  (Michael Fuhr <mike@fuhr.org>)
Список pgsql-general
On Thu, Jan 26, 2006 at 03:22:50PM -0700, Michael Fuhr wrote:
> On Thu, Jan 26, 2006 at 05:05:19PM -0500, Eric B. Ridge wrote:
> > Is there some kind of "TopXID" magic variable/function that I haven't
> > found in the documentation?
>
> Not in the standard installation, but I think a C function that
> returns GetTopTransactionId() should work.  It's trivial to write
> and examples have been posted before; search the archives.

Tom made a good point against using this value: it's not guaranteed
to be unique, for example after a dump and reload.  I suppose that's
a strong reason why the developers haven't provided such easy access
to it.

--
Michael Fuhr

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

Предыдущее
От: Michael Fuhr
Дата:
Сообщение: Re: "xmin" system column
Следующее
От: Scott Marlowe
Дата:
Сообщение: Re: Arrays