Re: New Instance of Variable Not Found in Subplan Bug - Mailing list pgsql-bugs

From Tom Lane
Subject Re: New Instance of Variable Not Found in Subplan Bug
Date
Msg-id 11108.1078520046@sss.pgh.pa.us
Whole thread Raw
In response to Re: New Instance of Variable Not Found in Subplan Bug  (Josh Berkus <josh@agliodbs.com>)
Responses Re: New Instance of Variable Not Found in Subplan Bug
List pgsql-bugs
Josh Berkus <josh@agliodbs.com> writes:
>> What do you mean by "reloading the view", exactly?

> I created the same view under a new name.    The new view runs fine.

[scratches head...]  That doesn't make any sense to me at all ...
there must be some difference between the two view definitions.
The planner doesn't have any statistics associated with views,
only with underlying tables (in fact it never even sees the views).

Please compare \d output for the two views.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: New Instance of Variable Not Found in Subplan Bug
Next
From: Josh Berkus
Date:
Subject: Re: New Instance of Variable Not Found in Subplan Bug