8.3beta3 ERROR: cached plan must not change result type

From: Louis-David Mitterrand <vindex+lists-pgsql-hackers(at)apartia(dot)org>
To: pgsql-hackers(at)postgresql(dot)org
Subject: 8.3beta3 ERROR: cached plan must not change result type
Date: 2007-11-28 15:36:50
Message-ID: 20071128153650.GA4026@apartia.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

I am seeing this error with 8.3beta3 on debian unstable:

2007-11-28 15:15:46 CET ERROR: cached plan must not change result type
2007-11-28 15:15:46 CET STATEMENT: SELECT s.*,
coalesce(d.firstname||'&nbsp;','')||coalesce(d.lastname,'') as person_name,
person_url(d.id_person),
t.person_type,
t.id_person
from show s
left join person_to_show t using (id_show)
left join person d using (id_person)
where s.id_show = $1

The query is sent by a mod_perl app and a restart of apache2 fixes it.
Let me know if you need more info.

Cheers,

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2007-11-28 15:45:31 Re: 8.3beta3 ERROR: cached plan must not change result type
Previous Message Sam Mason 2007-11-28 15:30:10 Re: Sorting Improvements for 8.4