Re: 7.3beta1 DROP COLUMN DEPENDENCY PROBLEM

Поиск
Список
Период
Сортировка
От Rod Taylor
Тема Re: 7.3beta1 DROP COLUMN DEPENDENCY PROBLEM
Дата
Msg-id 1031580956.268.10.camel@jester
обсуждение исходный текст
Ответ на 7.3beta1 DROP COLUMN DEPENDENCY PROBLEM  (tim@ametco.co.uk (Tim Knowles))
Список pgsql-hackers
On Fri, 2002-09-06 at 06:54, Tim Knowles wrote:
> Hi,
> 
> Been playing with the 7.3beta1 version and I've noticed a small
> problem with dependency checking when dropping a column.  If you have
> a view which uses JOIN's to join tables then dropping a column will

This has to do with the way the JOIN currently functions.  At the moment
the JOIN nodes record an alias which has all columns listed, which is
appropriately picked up by the dependency code.

Tom is debating whether or not the alias on columns not used in the
where or clause or returned is strictly necessary.

Indeed, if you delete the dependencies, then drop the column the view
continues to function but I'm not sure thats always the case.

--  Rod Taylor



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

Предыдущее
От: "David D. Kilzer"
Дата:
Сообщение: [SCRIPT] pguniqchk -- checks uniqueness of unique constraints on tables
Следующее
От: Jan Wieck
Дата:
Сообщение: Re: Rule updates and PQcmdstatus() issue