Re: BUG #5234: ALTER TABLE ... RENAME COLUMN change view definition incorrectly

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: BUG #5234: ALTER TABLE ... RENAME COLUMN change view definition incorrectly
Дата
Msg-id 20091210180243.GM15554@alvh.no-ip.org
обсуждение исходный текст
Ответ на Re: BUG #5234: ALTER TABLE ... RENAME COLUMN change view definition incorrectly  (Robert Haas <robertmhaas@gmail.com>)
Ответы Re: BUG #5234: ALTER TABLE ... RENAME COLUMN change view definition incorrectly  (Robert Haas <robertmhaas@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: BUG #5234: ALTER TABLE ... RENAME COLUMN change view definition incorrectly
Следующее
От: Robert Haas
Дата:
Сообщение: Re: BUG #5234: ALTER TABLE ... RENAME COLUMN change view definition incorrectly