Re: Query error corrected after vacuum - Mailing list pgsql-general

Matt Doucleff <matt@digitalfountain.com> writes:
> select name from files where dir_id =
>     (select id from dirs where domain_id =
>         (select id from domains where domain = 'foo'))

> ERROR:  ExecReScanSetParamPlan: extParam list of plan is NULL

Hm.  What version are you running?  What plan does EXPLAIN show for
the above query, in both the failing and non-failing states?  Also,
what are the declarations of the tables?

            regards, tom lane