Re: BUG #6050: Dump and restore of view after a schema change: can't restore the view - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #6050: Dump and restore of view after a schema change: can't restore the view
Date
Msg-id 14241.1307461282@sss.pgh.pa.us
Whole thread Raw
In response to Re: BUG #6050: Dump and restore of view after a schema change: can't restore the view  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: BUG #6050: Dump and restore of view after a schema change: can't restore the view
List pgsql-bugs
Robert Haas <robertmhaas@gmail.com> writes:
> If your point here is that you don't want to spend time hacking on
> this because it's a fairly marginal feature and therefore not terribly
> high on your priority list, I can understand that.  But if you're
> actually defending the current implementation, I'm going to have to
> respectfully disagree.  It's broken, and it sucks, and this is not the
> first complaint we've had about it.

The spec's definition of USING is broken and sucky, and we're
implementing it as best we can.  I don't feel a need to invent
strange nonstandard behavior to work around the fact that USING
is fragile *by definition*.  Complain to the standards committee
about that.

(Question: would you also have us try to work around the fact that
USING stops working if you rename one of the join columns?)

            regards, tom lane

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: ON DELETE CASCADE with multiple paths in PostgreSQL 9.x
Next
From: Daniel Cristian Cruz
Date:
Subject: Re: BUG #6050: Dump and restore of view after a schema change: can't restore the view