Re: Query error corrected after vacuum

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Matt Doucleff <matt(at)digitalfountain(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Query error corrected after vacuum
Date: 2000-11-12 06:27:25
Message-ID: 22846.974010445@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Matt Doucleff <matt(at)digitalfountain(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jason Davies 2000-11-12 13:39:16 Foreign key information
Previous Message Tod McQuillin 2000-11-12 04:05:37 Re: Query error corrected after vacuum