Re: Support retrieving value from any sequence

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Support retrieving value from any sequence
Дата
Msg-id CAKFQuwa2opnEXjsPRbTZRP5TnnEh10GiDtHC0=AFS5fUyst0Lw@mail.gmail.com
обсуждение исходный текст
Ответ на Support retrieving value from any sequence  (Thom Brown <thom@linux.com>)
Ответы Re: Support retrieving value from any sequence  (Thom Brown <thom@linux.com>)
Список pgsql-hackers
On Tue, Jul 14, 2015 at 10:52 AM, Thom Brown <thom@linux.com> wrote:
The use-case I have in mind is for finding out how close to the 32-bit integer limit sequences have reached.  At the moment, this isn't possible without creating a custom function to go fetch the last_value from the specified sequence.


​Why wouldn't you just query the catalog?​  I was under the impression last said values were extra-transactional so that table should reflect the global state.

What am I missing here?

David J.

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

Предыдущее
От: Simon Riggs
Дата:
Сообщение: Re: TABLESAMPLE patch is really in pretty sad shape
Следующее
От: Thom Brown
Дата:
Сообщение: Re: Support retrieving value from any sequence