Re: Summary and Plan for Hot Standby

Поиск
Список
Период
Сортировка
От Heikki Linnakangas
Тема Re: Summary and Plan for Hot Standby
Дата
Msg-id 4B056708.50803@enterprisedb.com
обсуждение исходный текст
Ответ на Re: Summary and Plan for Hot Standby  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Tom Lane wrote:
> Heikki Linnakangas <heikki.linnakangas@enterprisedb.com> writes:
>> Tatsuo Ishii wrote:
>>> Sorry for confusion. My example is under normal PostgreSQL, not under
>>> HS enabled.
> 
>> You get the same result in standby:
> 
> AFAICT Tatsuo's example just shows that we might wish to add a check
> for read-only transaction mode before parsing an INSERT/UPDATE/DELETE
> command.  But it seems relatively minor in any case --- at the worst
> you'd get an unexpected error message, no?

Right, it's harmless AFAICS. And it might actually be useful to be able
to prepare all queries right after connecting, even though the
connection is in not yet read-write.

It's the documentation (in source code or README) that's lacking, and
perhaps we should add more explicit checks for the "can't happen" cases,
just in case.

--  Heikki Linnakangas EnterpriseDB   http://www.enterprisedb.com


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Summary and Plan for Hot Standby
Следующее
От: Guillaume Lelarge
Дата:
Сообщение: Patch to change a pg_restore message