Re: ALTER DATABASE RENAME with HS/SR

Поиск
Список
Период
Сортировка
От Fujii Masao
Тема Re: ALTER DATABASE RENAME with HS/SR
Дата
Msg-id AANLkTi=+Ln3zP216cZoxcTpG_u_W1COqJvdMHJ-XMCX=@mail.gmail.com
обсуждение исходный текст
Ответ на Re: ALTER DATABASE RENAME with HS/SR  (Simon Riggs <simon@2ndQuadrant.com>)
Список pgsql-hackers
On Tue, Oct 5, 2010 at 5:11 PM, Simon Riggs <simon@2ndquadrant.com> wrote:
> On Tue, 2010-10-05 at 13:29 +0900, Fujii Masao wrote:
>> On Tue, Oct 5, 2010 at 3:42 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> > OTOH, we don't have a similar interlock to prevent renaming users
>> > who have active sessions, so maybe we are being overprotective here.
>>
>> Yep. What is worse is that we can drop users who have active sessions
>> on the standby. Then we can get the following error from those sessions:
>>
>>     => SELECT current_user;
>>     ERROR:  invalid role OID: 16384
>
> Hot Standby faithfully implements the current behaviour on the master in
> that case.

Oh, right. Sorry for noise.

Regards,

--
Fujii Masao
NIPPON TELEGRAPH AND TELEPHONE CORPORATION
NTT Open Source Software Center


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

Предыдущее
От: Simon Riggs
Дата:
Сообщение: Re: ALTER DATABASE RENAME with HS/SR
Следующее
От: Tatsuo Ishii
Дата:
Сообщение: pg_filedump for 9.0?