Re: Re-create dependent views on ALTER TABLE ALTER COLUMN ... TYPE? - Mailing list pgsql-hackers

From Andres Freund
Subject Re: Re-create dependent views on ALTER TABLE ALTER COLUMN ... TYPE?
Date
Msg-id 20140602175315.GH24145@awork2.anarazel.de
Whole thread Raw
In response to Re: Re-create dependent views on ALTER TABLE ALTER COLUMN ... TYPE?  (Stephen Frost <sfrost@snowman.net>)
List pgsql-hackers
On 2014-06-02 13:40:32 -0400, Stephen Frost wrote:
> Of course, there is a question about if it's worth it to keep around the
> exact text of each CREATE VIEW and build all this infrastructure for
> something which will only work properly in a specific subset of cases
> and in many others could break silently, essentially installing a very
> handy looking foot-gun.  Not sure I like that either.

I don't think any solution that requires that is going to be
workable. It'll break in far too many cases that currently are handled
transparently. Starting with RENAME, followed by lots of other
stuff. It'd also be very confusing because pg_dump doesn't use it...

Greetings,

Andres Freund

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



pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: Re-create dependent views on ALTER TABLE ALTER COLUMN ... TYPE?
Next
From: Alvaro Herrera
Date:
Subject: Re: recovery testing for beta