Re: 8.3beta3 ERROR: cached plan must not change result type

On Wed, Nov 28, 2007 at 04:51:17PM +0100, Louis-David Mitterrand wrote:
> On Wed, Nov 28, 2007 at 10:45:31AM -0500, Tom Lane wrote:
> > Louis-David Mitterrand <vindex+lists-pgsql-hackers@apartia.org> writes:
> > > 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
> > 
> > > Let me know if you need more info.
> > 
> > Yes.
> 
> Okay :) I guess I had it coming.
> 
> The only thing I know is this error started showing up in the logs at 
> 15:15:46 making our site unavailble until I restarted apache.
> 
> No postgres code has been modified recently on the app and it's the 
> first time I see that error. 
> 
> Also I don't know, yet, how to reproduce it. Will try and report.

Wow, this above email took three days to reach to list.
Received: from maia-2.hub.org (maia-2.hub.org [200.46.204.187])        by zenon.apartia.fr (Postfix) with ESMTP id
2B95E59C5B43C       for <vindex+lists-pgsql-hackers@apartia.org>; Sat,  1 Dec 2007 02:14:00        +0100 (CET)Received:
frompostgresql.org (postgresql.org [200.46.204.71])        by maia-2.hub.org (Postfix) with ESMTP id C5C1F2CA2E2
for<vindex+lists-pgsql-hackers@apartia.org>; Wed, 28 Nov 2007 11:51:20        -0400 (AST)
 

Why did maia-2.hub.org keep it so long in its belly?