Re: age(xid) on hot standby

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: age(xid) on hot standby
Дата
Msg-id 4643.1325100934@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: age(xid) on hot standby  (Alvaro Herrera <alvherre@commandprompt.com>)
Ответы Re: age(xid) on hot standby  (Peter Eisentraut <peter_e@gmx.net>)
Список pgsql-hackers
Alvaro Herrera <alvherre@commandprompt.com> writes:
> Excerpts from Peter Eisentraut's message of mié dic 28 15:04:09 -0300 2011:
>> On a hot standby, this fails with:
>> ERROR:  cannot assign TransactionIds during recovery

> I think we could just have the xid_age call
> GetCurrentTransactionIdIfAny, and if that returns InvalidXid, use
> ReadNewTransactionId instead.  That xid_age assigns a transaction seems
> more of an accident than really intended.

The trouble with using ReadNewTransactionId is that it makes the results
volatile, not stable as the function is declared to be.
        regards, tom lane


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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: age(xid) on hot standby
Следующее
От: Heikki Linnakangas
Дата:
Сообщение: Re: spinlocks on HP-UX