Horton

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

Andres Freund <andres@2ndquadrant.com>

View thread View on postgr.es
From: Andres Freund <andres@2ndquadrant.com>
To: Josh Berkus <josh@agliodbs.com>
Cc: Stephen Frost <sfrost@snowman.net>, Robert Haas <robertmhaas@gmail.com>, Tom Lane <tgl@sss.pgh.pa.us>, ash <ash@commandprompt.com>, "pgsql-hackers@postgresql.org" <pgsql-hackers@postgresql.org>
Date: 2014-06-02T17:51:59Z
Lists: pgsql-hackers 
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

Commits

  1. Allow CREATE OR REPLACE VIEW to add columns to the _end_ of the view.