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

Поиск
Список
Период
Сортировка
От Stephen Frost
Тема Re: BUG #11350: ALTER SYSTEM is not DDL?
Дата
Msg-id 20140904191456.GW16422@tamriel.snowman.net
обсуждение исходный текст
Ответ на Re: BUG #11350: ALTER SYSTEM is not DDL?  (Amit Kapila <amit.kapila16@gmail.com>)
Ответы Re: BUG #11350: ALTER SYSTEM is not DDL?  (Andres Freund <andres@2ndquadrant.com>)
Re: BUG #11350: ALTER SYSTEM is not DDL?  (Amit Kapila <amit.kapila16@gmail.com>)
Список pgsql-bugs
* 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 =3D ddl'.
> >
> > Am I missing something?
>=20
> 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...

    Thanks,

        Stephen

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

Предыдущее
От: Fujii Masao
Дата:
Сообщение: Re: BUG #11335: an invalid prepare statement causes crash at log_statement = 'mod' or 'ddl'.
Следующее
От: Andres Freund
Дата:
Сообщение: Re: BUG #11350: ALTER SYSTEM is not DDL?