Re: ALTER TABLE ... NOREWRITE option - Mailing list pgsql-hackers

From Tom Lane
Subject Re: ALTER TABLE ... NOREWRITE option
Date
Msg-id 2105.1354589073@sss.pgh.pa.us
Whole thread Raw
In response to Re: ALTER TABLE ... NOREWRITE option  (Josh Berkus <josh@agliodbs.com>)
Responses Re: ALTER TABLE ... NOREWRITE option  (Josh Berkus <josh@agliodbs.com>)
List pgsql-hackers
Josh Berkus <josh@agliodbs.com> writes:
>> EXPLAIN ALTER TABLE would be the next step I guess. I discovered plenty
>> of magic tricks when working on the rewriting support for that command,
>> and I think exposing them in the EXPLAIN output would go a long way
>> towards reducing some POLA violations.

> I think this would be cool on its own merits.

> However, for a very large user group -- users with ORMs which do their
> own DDL migrations -- we could also use a way to log or WARN for table
> rewrites.  Since the ORMs are not gonna do an EXPLAIN.

An ORM is also quite unlikely to pay attention to a warning, much less a
postmaster log entry ... so your argument seems unfounded from here.
        regards, tom lane



pgsql-hackers by date:

Previous
From: Josh Berkus
Date:
Subject: Re: ALTER TABLE ... NOREWRITE option
Next
From: Andrew Dunstan
Date:
Subject: Re: json accessors