Re: Re-create dependent views on ALTER TABLE ALTER COLUMN ... TYPE?

On 2014-06-02 10:48:02 -0700, Josh Berkus wrote:
> On 06/02/2014 10:40 AM, Stephen Frost wrote:
> > Tom's point goes back to what I was trying to drive at originally-
> > people should have to ask for this.  Perhaps we can provide a way for
> > them to ask which is explicit enough that they understand "this might
> > not do exactly what you think it does", akin to what happens today with
> > a drop-and-recreate-everything approach.  'CASCADE' might not be
> > sufficient to meet that, maybe 'CASCADE REBUILD' or something?
> 
> I think CASCADE is sufficient; what else could a user mean by ALTER
> TABLE ... CASCADE?

"Please also change the table's children".

Greetings,

Andres Freund

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