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

From Josh Berkus
Subject Re: ALTER TABLE ... NOREWRITE option
Date
Msg-id 50BD57E5.7060404@agliodbs.com
Whole thread Raw
In response to Re: ALTER TABLE ... NOREWRITE option  (Dimitri Fontaine <dimitri@2ndQuadrant.fr>)
Responses Re: ALTER TABLE ... NOREWRITE option  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
> 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.

-- 
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com



pgsql-hackers by date:

Previous
From: Jeff Davis
Date:
Subject: Commits 8de72b and 5457a1 (COPY FREEZE)
Next
From: Tom Lane
Date:
Subject: Re: ALTER TABLE ... NOREWRITE option