Query error corrected after vacuum

Поиск
Список
Период
Сортировка
От Matt Doucleff
Тема Query error corrected after vacuum
Дата
Msg-id 3A0DF27B.A5BD4D1D@digitalfountain.com
обсуждение исходный текст
Ответы Re: Query error corrected after vacuum
Re: Query error corrected after vacuum
Список 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 по дате отправления:

Предыдущее
От: Igor Roboul
Дата:
Сообщение: Re: 'currency' question; precision/decimal meaing
Следующее
От: oberpwd@anubis.network.com (Wade D. Oberpriller)
Дата:
Сообщение: More help on PL/Perl