Re: BUG #11350: ALTER SYSTEM is not DDL?

Поиск
Список
Период
Сортировка
От Tomonari Katsumata
Тема Re: BUG #11350: ALTER SYSTEM is not DDL?
Дата
Msg-id 5409123A.5070502@po.ntts.co.jp
обсуждение исходный текст
Ответ на Re: BUG #11350: ALTER SYSTEM is not DDL?  (Andres Freund <andres@2ndquadrant.com>)
Список pgsql-bugs
Hi,

Thank you for checking this.

Originally this feature might have been close to SET,
but currently has an 'ALTER' keyword.
Many users don't know this and would be confusing with reading the manual.

I made a quick patch for fixing this.
Could you check it?

regards,
-------------
Tomonari Katsumata

(2014/09/05 5:12), Andres Freund wrote:
 > On 2014-09-04 15:14:56 -0400, Stephen Frost wrote:
 >> * Amit Kapila (amit.kapila16@gmail.com) wrote:
 >>> On Thu, Sep 4, 2014 at 10:43 AM, <katsumata.tomonari@po.ntts.co.jp>
wrote:
 >>>> So I think log message should be outputted when executing ALTER SYSTEM
 >>> with
 >>>> 'log_statement = ddl'.
 >>>>
 >>>> Am I missing something?
 >>>
 >>> Currently it is considered similar to SET statement as it performs
 >>> similar operation except that the value for configuration gets set
 >>> in configuration file.  Do you see any reason for it to be considered
 >>> differently except that the command has ALTER keyword?
 >>
 >> Uh, it's nothing like SET as SET only affects the current session.
 >>
 >> It's much, much closer to ALTER ROLE, which correctly logs at the DDL
 >> level.  This should be fixed, and before 9.4 goes out...
 >
 > +1.
 >
 > Greetings,
 >
 > Andres Freund
 >



Вложения

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

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: BUG #11350: ALTER SYSTEM is not DDL?
Следующее
От: Amit Kapila
Дата:
Сообщение: Re: BUG #11350: ALTER SYSTEM is not DDL?