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

From Alvaro Herrera
Subject Re: BUG #5234: ALTER TABLE ... RENAME COLUMN change view definition incorrectly
Date
Msg-id 20091210180243.GM15554@alvh.no-ip.org
Whole thread Raw
In response to Re: BUG #5234: ALTER TABLE ... RENAME COLUMN change view definition incorrectly  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: BUG #5234: ALTER TABLE ... RENAME COLUMN change view definition incorrectly
List pgsql-bugs
Robert Haas escribió:
> On Thu, Dec 10, 2009 at 11:57 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:

> > Hmm.  Cute, 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.

--
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

pgsql-bugs by date:

Previous
From: Tom Lane
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