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

2007-12-02 Thread Alvaro Herrera
Louis-David Mitterrand wrote: > 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 <[EMAIL PROTECTED]>; S

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

2007-12-01 Thread Louis-David Mitterrand
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 <[EMAIL PROTECTED]> writes: > > > I am seeing this error with 8.3beta3 on debian unstable: > > > > > 2007-11-28 15:15:46 CET ERROR: cach

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

2007-11-28 Thread Louis-David Mitterrand
On Wed, Nov 28, 2007 at 10:45:31AM -0500, Tom Lane wrote: > Louis-David Mitterrand <[EMAIL PROTECTED]> 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. >

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

2007-11-28 Thread Tom Lane
Louis-David Mitterrand <[EMAIL PROTECTED]> 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. regards, tom lane

[HACKERS] 8.3beta3 ERROR: cached plan must not change result type

2007-11-28 Thread Louis-David Mitterrand
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.lastname,'') as person_na