Horton

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

Josh Berkus <josh@agliodbs.com>

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

Commits

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