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

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Rod Taylor <rbt(at)zort(dot)ca>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, tim(at)ametco(dot)co(dot)uk, pgsql-bugs(at)postgresql(dot)org
Subject: Re: Bug #759: 7.3beta1 DROP COLUMN DEPENDENCY PROBLEM
Date: 2002-09-11 04:02:17
Message-ID: 200209110402.g8B42HC11572@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)zort(dot)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(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Bruce Momjian 2002-09-11 04:12:52 Re: Schemas not available for pl/pgsql %TYPE....
Previous Message Tom Lane 2002-09-11 03:30:19 Re: make unsuccessful on mac os x 10.2