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

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?

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