8.3beta3 ERROR: cached plan must not change result type - Mailing list pgsql-hackers

From Louis-David Mitterrand
Subject 8.3beta3 ERROR: cached plan must not change result type
Date
Msg-id 20071128153650.GA4026@apartia.fr
Whole thread Raw
Responses Re: 8.3beta3 ERROR: cached plan must not change result type  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 type2007-11-28 15:15:46 CET STATEMENT:  SELECT s.*,
         coalesce(d.firstname||' ','')||coalesce(d.lastname,'') as person_name,
person_url(d.id_person),           t.person_type,            t.id_person            from show s            left join
person_to_showt 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,


pgsql-hackers by date:

Previous
From: Sam Mason
Date:
Subject: Re: Sorting Improvements for 8.4
Next
From: Tom Lane
Date:
Subject: Re: 8.3beta3 ERROR: cached plan must not change result type