Query error corrected after vacuum - Mailing list pgsql-general

From Matt Doucleff
Subject Query error corrected after vacuum
Date
Msg-id 3A0DF27B.A5BD4D1D@digitalfountain.com
Whole thread Raw
Responses Re: Query error corrected after vacuum
Re: Query error corrected after vacuum
List pgsql-general
Hi,

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

My test program drops the relevant tables, then recreates them before performing the above query.  I don't get this
errorif I run vacuum after creating the "dirs" table.  This problem sounds similar to an old post I found: 

http://looking-glass.usask.ca:82/mhonarc/pgsql-general/1999-02/msg00318.html

Please respond via personal email. Thank you for you help,

    Matt

pgsql-general by date:

Previous
From: Igor Roboul
Date:
Subject: Re: 'currency' question; precision/decimal meaing
Next
From: oberpwd@anubis.network.com (Wade D. Oberpriller)
Date:
Subject: More help on PL/Perl