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

From Amit Kapila
Subject Re: BUG #11350: ALTER SYSTEM is not DDL?
Date
Msg-id CAA4eK1JOajg2Rt7pQyE7rq31e4ESzzCfcjHpG2LdGim-y9zB=g@mail.gmail.com
Whole thread Raw
In response to BUG #11350: ALTER SYSTEM is not DDL?  (katsumata.tomonari@po.ntts.co.jp)
Responses Re: BUG #11350: ALTER SYSTEM is not DDL?
List pgsql-bugs
On Thu, Sep 4, 2014 at 10:43 AM, <katsumata.tomonari@po.ntts.co.jp> wrote:
>
> The following bug has been logged on the website:
>
> Bug reference:      11350
> Logged by:          Tomonari Katsumata
> Email address:      katsumata.tomonari@po.ntts.co.jp
> PostgreSQL version: 9.4beta2
> Operating system:   RHEL6.4 x86_64
> Description:
>
> The document says about log_statement:
> >ddl logs all data definition statements, such as CREATE, ALTER, and DROP
> statements.
>
> 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?

Note-
Initially we have thought it to be a variant of SET (SET PERSISTENT),
however later it turns out that it will be better to use ALTER SYSTEM
for this command.

With Regards,
Amit Kapila.
EnterpriseDB: http://www.enterprisedb.com

pgsql-bugs by date:

Previous
From: katsumata.tomonari@po.ntts.co.jp
Date:
Subject: BUG #11350: ALTER SYSTEM is not DDL?
Next
From: andreas.papst@univie.ac.at
Date:
Subject: BUG #11353: Documentation for SET AUTOCOMMIT is wrong