Re: [HACKERS] BUG: type of "xxxx" does not match that when preparing the plan

2008-01-31 Thread Hubert FONGARNAND
I'm sorry, you're right it fails too with older version of postgresql Le jeudi 31 janvier 2008 à 10:35 -0500, Tom Lane a écrit : > Hubert FONGARNAND <[EMAIL PROTECTED]> writes: > > We are testing PostGreSQL 8.3 RC2 on our beta plateform and we are > > facing some problems with plpgsql function.

Re: [HACKERS] BUG: type of "xxxx" does not match that when preparing the plan

2008-01-31 Thread Tom Lane
Hubert FONGARNAND <[EMAIL PROTECTED]> writes: > We are testing PostGreSQL 8.3 RC2 on our beta plateform and we are > facing some problems with plpgsql function. > Here's a failing test case, which worked well on postgresql 8.1 : Really? I get the 'does not match' error in every release back to 7

[HACKERS] BUG: type of "xxxx" does not match that when preparing the plan

2008-01-31 Thread Hubert FONGARNAND
Hi, We are testing PostGreSQL 8.3 RC2 on our beta plateform and we are facing some problems with plpgsql function. Here's a failing test case, which worked well on postgresql 8.1 : Create this function : CREATE OR REPLACE FUNCTION test(param integer) RETURNS text AS $BODY$DECLARE attr