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||' ','')||coalesce(d.las tname,'') 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,

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org