Re: Thinking about EXPLAIN ALTER TABLE - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Thinking about EXPLAIN ALTER TABLE
Date
Msg-id 26597.1544460770@sss.pgh.pa.us
Whole thread Raw
In response to Re: Thinking about EXPLAIN ALTER TABLE  (Simon Riggs <simon@2ndquadrant.com>)
Responses Re: Thinking about EXPLAIN ALTER TABLE
List pgsql-hackers
Simon Riggs <simon@2ndquadrant.com> writes:
> On Mon, 10 Dec 2018 at 16:32, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> We were just busy shooting down a different suggestion of
>> behavior-changing GUCs.  A GUC that turns all ALTERs into no-ops
>> sure seems like a foot-gun to me.

> How would you test a script? Manually edit each one with the new option?
> Manual editing is more of a foot gun.

I don't see how EXPLAIN ALTER TABLE would meaningfully be something
you use in a script.  If you have a script with many steps including
ALTER TABLEs, it's likely that each ALTER depends on the effects of
prior steps, and it's even more likely that the steps after an ALTER
depend on it having executed.

            regards, tom lane


pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: Thinking about EXPLAIN ALTER TABLE
Next
From: Simon Riggs
Date:
Subject: Re: Thinking about EXPLAIN ALTER TABLE