> > RELOADING the view fixed the error.
> What do you mean by "reloading the view", exactly?
I created the same view under a new name. The new view runs fine. I
suspect that if I REPLACED the view, it would be fixed, but I don't want to
do that if we want to analyze it further.
> The cost numbers here are very small; are the tables themselves small, or
> did you reload them too?
The tables are quite small, the largest < 200 rows. This view just links a
bunch of reference lists.
Aglio Database Solutions
In response to
pgsql-bugs by date
|Next:||From: Tom Lane||Date: 2004-03-05 20:50:59|
|Subject: Re: New Instance of Variable Not Found in Subplan Bug |
|Previous:||From: Josh Berkus||Date: 2004-03-05 20:47:41|
|Subject: Re: New Instance of Variable Not Found in Subplan Bug|