| From: | Andres Freund <andres(at)2ndquadrant(dot)com> |
|---|---|
| To: | Amit Kapila <amit(dot)kapila16(at)gmail(dot)com> |
| Cc: | Craig Ringer <craig(at)2ndquadrant(dot)com>, Stephen Frost <sfrost(at)snowman(dot)net>, katsumata(dot)tomonari(at)po(dot)ntts(dot)co(dot)jp, PostgreSQL Bugs <pgsql-bugs(at)postgresql(dot)org> |
| Subject: | Re: BUG #11350: ALTER SYSTEM is not DDL? |
| Date: | 2014-09-19 07:35:25 |
| Message-ID: | 20140919073525.GB4277@alap3.anarazel.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
On 2014-09-19 12:50:24 +0530, Amit Kapila wrote:
> On Fri, Sep 19, 2014 at 9:49 AM, Craig Ringer <craig(at)2ndquadrant(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kyotaro HORIGUCHI | 2014-09-19 08:15:44 | Re: BUG #11441: Weird (and seems wrong) behavior of partial indexes with order by/limit |
| Previous Message | Amit Kapila | 2014-09-19 07:20:24 | Re: BUG #11350: ALTER SYSTEM is not DDL? |