Re: pgpool versus sequences

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: pgpool versus sequences
Дата
Msg-id 29868.1306973740@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: pgpool versus sequences  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
I wrote:
> Please note also that what pgpool users have got right now is a time
> bomb, which is not better than immediately-visible breakage.

BTW, so far as that goes, I suggest that we tweak nextval() and setval()
to force the sequence tuple's xmax to zero.  That will provide a simple
recovery path for anyone who's at risk at the moment.  Of course, this
has to go hand-in-hand with the change to forbid SELECT FOR UPDATE,
else those operations would risk breaking active tuple locks.
        regards, tom lane


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

Предыдущее
От: Tatsuo Ishii
Дата:
Сообщение: Re: pgpool versus sequences
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: storing TZ along timestamps