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

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

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