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

On 2014-09-19 12:50:24 +0530, Amit Kapila wrote:
> On Fri, Sep 19, 2014 at 9:49 AM, Craig Ringer <craig@2ndquadrant.com> wrote:
> >
> > On 09/05/2014 08:32 PM, Amit Kapila wrote:
> > >
> > > and Alter System affects at system level, both of these can't
> > > be considered as DDL, may be a separate category.
> >
> > Like CREATE USER / CREATE ROLE / CREATE DATABASE ?
> >
> > All those are logged as DDL.
>
> They are different from ALTER SYSTEM in terms that they create/modify
> the object (here object can be any database or cluster object) property.
>
> Can you tell me that if we want to make ALTER SYSTEM as DDL, then
> why SET or CHECKPOINT commands can't be DDL?

Really? Because neither has persistent effects? I'd be perfectly fine if
we started logging CHECKPOINT; as DDL - SET on the hand doesn't make
much sense.

Greetings,

Andres Freund

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