Horton

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

Alex Shulgin <ash@commandprompt.com>

View thread View on postgr.es
From: ash <ash@commandprompt.com>
To: David Fetter <david@fetter.org>
Cc: pgsql-hackers@postgresql.org
Date: 2014-05-26T20:37:32Z
Lists: pgsql-hackers 
David Fetter <david@fetter.org> writes:

> On Mon, May 26, 2014 at 06:25:09PM +0400, ash wrote:
>> Hi Hackers,
>> 
>> This came up recently on general list (and I've just hit the same issue today):
>>   http://www.postgresql.org/message-id/CAB7nPqTLmMn1LTb5WE0v0dO57iP0U73yKwzbZytAXDF1CAWLZg@mail.gmail.com
>> 
>> Why couldn't postgres re-create the dependent views automatically?  I
>> mean it knows which views depend on the altered column and keeps the
>> view definition, no?
>
> Also worth considering: functions which take any part of the view as a
> parameter.

Sorry, I don't get it: do you suggest we should re-create dependent
functions too?

I don't think that's feasible, but there is certainly a use case for
silently re-defining the views together with alteration of the joined
table.

--
Alex

Commits

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