Re: ALTER DATABASE RENAME with HS/SR

Поиск
Список
Период
Сортировка
От Simon Riggs
Тема Re: ALTER DATABASE RENAME with HS/SR
Дата
Msg-id 1286266294.2025.887.camel@ebony
обсуждение исходный текст
Ответ на Re: ALTER DATABASE RENAME with HS/SR  (Fujii Masao <masao.fujii@gmail.com>)
Ответы Re: ALTER DATABASE RENAME with HS/SR  (Fujii Masao <masao.fujii@gmail.com>)
Список pgsql-hackers
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.

-- Simon Riggs           www.2ndQuadrant.comPostgreSQL Development, 24x7 Support, Training and Services



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

Предыдущее
От: Heikki Linnakangas
Дата:
Сообщение: Re: OUTER keyword
Следующее
От: Fujii Masao
Дата:
Сообщение: Re: ALTER DATABASE RENAME with HS/SR