Re: New Instance of Variable Not Found in Subplan Bug

Tom,

> It's presumably dependent on the contents of pg_statistic and the
> relpages/reltuples counts in pg_class for the tables involved.
> You could likely reproduce it by migrating that data to your laptop.
> It would take a little bit of hacking to get the pg_statistic data
> in (adjusting starelid for instance) but I think it's doable.
>
> Note that the planner control settings (eg effective_cache_size) might
> also need to be copied.

Hmmm ... could I do it through a binary file copy?   I'm on a bit of a
deadline here, and need to replace the bad view in the next hour or so.

--
-Josh Berkus
 Aglio Database Solutions
 San Francisco