Re: Bug #759: 7.3beta1 DROP COLUMN DEPENDENCY PROBLEM

Поиск
Список
Период
Сортировка
От Rod Taylor
Тема Re: Bug #759: 7.3beta1 DROP COLUMN DEPENDENCY PROBLEM
Дата
Msg-id 1031421431.15580.4.camel@jester
обсуждение исходный текст
Ответ на Re: Bug #759: 7.3beta1 DROP COLUMN DEPENDENCY PROBLEM  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Bug #759: 7.3beta1 DROP COLUMN DEPENDENCY PROBLEM  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список pgsql-bugs
On Fri, 2002-09-06 at 19:30, Tom Lane wrote:
> Rod Taylor <rbt@zort.ca> writes:
> > The big difference is that the INNER JOIN code needs to drop one of the
> > colb's coming up with a virtual relation cola, colb, colc; where the
> > other doesn't have such a renaming scheme.
>
> On reflection I think it might be possible to make this work the way
> Tim wants: I think it would be okay for the dependency-extracter code
> to ignore the Var lists that are attached to join RTEs.  Needs more
> thought though, and I don't plan to think about it before Monday;
> I'm taking the weekend off ...

Your right.  The view continues to function perfectly fine with the
column dropped (did a delete from pg_depend to allow it).

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: GCC3.2 and Postgres 7.2.2
Следующее
От: Markus Bertheau
Дата:
Сообщение: crash in apache