Re: BUG #5234: ALTER TABLE ... RENAME COLUMN change view definition incorrectly - Mailing list pgsql-bugs

From Robert Haas
Subject Re: BUG #5234: ALTER TABLE ... RENAME COLUMN change view definition incorrectly
Date
Msg-id 603c8f070912101003t67a36a53y3b2285c582d5b5b7@mail.gmail.com
Whole thread Raw
In response to Re: BUG #5234: ALTER TABLE ... RENAME COLUMN change view definition incorrectly  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-bugs
On Thu, Dec 10, 2009 at 1:02 PM, Alvaro Herrera
<alvherre@commandprompt.com> wrote:
> Robert Haas escribi=F3:
>> On Thu, Dec 10, 2009 at 11:57 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>
>> > Hmm. =A0Cute, but I wonder why we shouldn't just be throwing an error.
>> > As I said last night, the only thing I see wrong with the current
>> > behavior is that the error message isn't phrased in a way that makes
>> > it obvious it's the user's fault.
>>
>> I think the problem we're trying to solve is that the view works but
>> it isn't dumpable.
>
> So it would also be a solution that the ALTER TABLE that renamed the
> column throwed an error if there's a view that requires the name.

Yes.  I don't think it's as good of a solution, but it is a solution.

...Robert

pgsql-bugs by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: BUG #5234: ALTER TABLE ... RENAME COLUMN change view definition incorrectly
Next
From: Robert Haas
Date:
Subject: Re: BUG #5234: ALTER TABLE ... RENAME COLUMN change view definition incorrectly