Re: BUG #11350: ALTER SYSTEM is not DDL? - Mailing list pgsql-bugs

From Andres Freund
Subject Re: BUG #11350: ALTER SYSTEM is not DDL?
Date
Msg-id 20140904201248.GE3625@alap3.anarazel.de
Whole thread Raw
In response to Re: BUG #11350: ALTER SYSTEM is not DDL?  (Stephen Frost <sfrost@snowman.net>)
Responses Re: BUG #11350: ALTER SYSTEM is not DDL?
List 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 by date:

Previous
From: Stephen Frost
Date:
Subject: Re: BUG #11350: ALTER SYSTEM is not DDL?
Next
From: Tomonari Katsumata
Date:
Subject: Re: BUG #11350: ALTER SYSTEM is not DDL?