Re: About "Allow VIEW/RULE recompilation when the underlying tables change"

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Robert Haas <robertmhaas(at)gmail(dot)com>
Cc: suzhiyang <suzhiyang(at)gmail(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: About "Allow VIEW/RULE recompilation when the underlying tables change"
Date: 2009-12-19 04:24:01
Message-ID: 18746.1261196641@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Robert Haas <robertmhaas(at)gmail(dot)com> writes:
> On Fri, Dec 18, 2009 at 10:39 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>> The TODO item is terribly underdocumented, but I think what it's on
>> about is that right now we refuse commands like ALTER COLUMN TYPE if
>> the column is referenced in a view. It would be nice to propagate
>> such a change into views if possible.

> I'm unconvinced that this is, as you would say, even mildly sane.

I've updated the TODO item to link to this discussion, so at least the
next three people who pop up with "let's just store the view source!"
will have some idea of what they're up against.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2009-12-19 04:28:17 Re: About "Allow VIEW/RULE recompilation when the underlying tables change"
Previous Message Robert Haas 2009-12-19 03:58:00 Re: About "Allow VIEW/RULE recompilation when the underlying tables change"