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

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