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

On Sat, 11 Nov 2000, Matt Doucleff wrote:

> I'm getting the following error:
>
> 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

I don't know what's causing the error, but the above query should be the
same as this multi-table join:

select f.name from files f, dirs di, domains do
where f.dir_id = di.id
and di.domain_id = do.id
and do.domain = 'foo'

So if you can't get the nested sub-selects working the above query may
work better.
--
Tod McQuillin