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

From: Rod Taylor <rbt(at)zort(dot)ca>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: 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-07 17:57:10
Message-ID: 1031421431.15580.4.camel@jester
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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).

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Michael Fortin 2002-09-08 15:52:53 make unsuccessful on mac os x 10.2
Previous Message Peter Eisentraut 2002-09-07 16:21:43 Re: GCC3.2 and Postgres 7.2.2