Re: 7.3beta1 DROP COLUMN DEPENDENCY PROBLEM

From: Rod Taylor <rbt(at)rbt(dot)ca>
To: Tim Knowles <tim(at)ametco(dot)co(dot)uk>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: 7.3beta1 DROP COLUMN DEPENDENCY PROBLEM
Date: 2002-09-09 14:15:56
Message-ID: 1031580956.268.10.camel@jester
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Teodor Sigaev 2002-09-09 14:19:42 Re: contrib/tsearch
Previous Message Jan Wieck 2002-09-09 14:15:47 Re: Rule updates and PQcmdstatus() issue