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

From Bruce Momjian
Subject Re: Bug #759: 7.3beta1 DROP COLUMN DEPENDENCY PROBLEM
Date
Msg-id 200209110402.g8B42HC11572@candle.pha.pa.us
Whole thread Raw
In response to Re: Bug #759: 7.3beta1 DROP COLUMN DEPENDENCY PROBLEM  (Rod Taylor <rbt@zort.ca>)
Responses Re: Bug #759: 7.3beta1 DROP COLUMN DEPENDENCY PROBLEM
List pgsql-bugs
Is this a TODO item or something for beta2?

---------------------------------------------------------------------------

Rod Taylor wrote:
> 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).
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: make unsuccessful on mac os x 10.2
Next
From: Tom Lane
Date:
Subject: Re: Bug #759: 7.3beta1 DROP COLUMN DEPENDENCY PROBLEM