Re: ALTER DATABASE RENAME with HS/SR

Поиск
Список
Период
Сортировка
От Fujii Masao
Тема Re: ALTER DATABASE RENAME with HS/SR
Дата
Msg-id AANLkTim71+ST35=ZkzsqZH8MkSPNxdYikygawA2uyv6x@mail.gmail.com
обсуждение исходный текст
Ответ на Re: ALTER DATABASE RENAME with HS/SR  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: ALTER DATABASE RENAME with HS/SR  (Simon Riggs <simon@2ndQuadrant.com>)
Список pgsql-hackers
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

Regards,

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


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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: ugly locking corner cases ...
Следующее
От: Pavel Stehule
Дата:
Сообщение: Re: Basic JSON support