Re: Bug #759: 7.3beta1 DROP COLUMN DEPENDENCY PROBLEM - Mailing list pgsql-bugs

From Rod Taylor
Subject Re: Bug #759: 7.3beta1 DROP COLUMN DEPENDENCY PROBLEM
Date
Msg-id 1031421431.15580.4.camel@jester
Whole thread Raw
In response to Re: Bug #759: 7.3beta1 DROP COLUMN DEPENDENCY PROBLEM  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Bug #759: 7.3beta1 DROP COLUMN DEPENDENCY PROBLEM
List 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 by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: GCC3.2 and Postgres 7.2.2
Next
From: Markus Bertheau
Date:
Subject: crash in apache