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

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Re: BUG #11350: ALTER SYSTEM is not DDL?
Дата
Msg-id 20140904201248.GE3625@alap3.anarazel.de
обсуждение исходный текст
Ответ на Re: BUG #11350: ALTER SYSTEM is not DDL?  (Stephen Frost <sfrost@snowman.net>)
Ответы Re: BUG #11350: ALTER SYSTEM is not DDL?  (Tomonari Katsumata <katsumata.tomonari@po.ntts.co.jp>)
Список pgsql-bugs
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

--
 Andres Freund                       http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services

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

Предыдущее
От: Stephen Frost
Дата:
Сообщение: Re: BUG #11350: ALTER SYSTEM is not DDL?
Следующее
От: Tomonari Katsumata
Дата:
Сообщение: Re: BUG #11350: ALTER SYSTEM is not DDL?