Horton

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

Robert Haas <robertmhaas@gmail.com>

View thread View on postgr.es
From: Robert Haas <robertmhaas@gmail.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Stephen Frost <sfrost@snowman.net>, ash <ash@commandprompt.com>, "pgsql-hackers@postgresql.org" <pgsql-hackers@postgresql.org>
Date: 2014-06-03T20:31:55Z
Lists: pgsql-hackers 
On Tue, Jun 3, 2014 at 10:14 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> If we had such a mechanism,
>> then perhaps someone could build a UI providing the sort of user
>> feedback you're suggesting to help them use it more safely.  But isn't
>> the core server support the first thing?
>
> I'm guessing you did not read
> http://www.postgresql.org/message-id/18723.1401734537@sss.pgh.pa.us

Argh, sorry, I saw that go by and it went past my eyes but obviously I
didn't really absorb it.  I guess we could do it that way.  But it
seems like quite a hassle to me; I think we're going to continue to
get complaints here until this is Easy.  And if it can't be made Easy,
then we're going to continue to get complaints forever.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

Commits

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