BUG when migrating from 8.0 to 8.1 with create temp table - Mailing list pgsql-general

Hi all,

  I just migrated from 8.0 to 8.1 and one of my stored procecure just
hang when trying to create a temp table

Here is my call:

select * from usp_Comptabilite_AgeDeCompteClient('M', null,
'2005-01-28', '1', '1', '0', null)

If you look below in the log you will see that the function just hang
when creating T_CP1 table.

Is that a know bug .. this code worked with 8.0

Thanks for your help
Best Regards
/David



--- FUNCTION
CREATE OR REPLACE FUNCTION usp_Comptabilite_AgeDeCompteClient(VARCHAR,
VARCHAR, DATE, BOOLEAN, BOOLEAN, INT, VARCHAR) RETURNS refcursor  AS $$
DECLARE

     companyId ALIAS FOR $1;
     Compte ALIAS FOR $2;
     DateRef ALIAS FOR $3;

     DateType ALIAS FOR $4;
     Tri ALIAS FOR $5;
     NBJour ALIAS FOR $6;
     BORRNUMR ALIAS FOR $7;
     DateRef_ DATE;

     ref refcursor;
     statement varchar(4000);
     temp RECORD;

BEGIN

    IF (DateRef IS NOT NULL) THEN
        DateRef_:=DateRef;
    ELSE
        DateRef_:=CURRENT_DATE;
    END IF;



  --  Toutes les ressources présentes (incluant le regroupement comptable)
    EXECUTE '
    CREATE TEMP TABLE T_RR  (
        RRNUM VARCHAR(10) PRIMARY KEY
    ) ON COMMIT DROP';

    EXECUTE '
    CREATE TEMP TABLE T_CR1  (
        CRNUM INT PRIMARY KEY,
        CRYPNUM VARCHAR(10),
        CRMONT DECIMAL,
        CRDATE DATE,
        CRRRNUM VARCHAR(10),
        CRACNUM VARCHAR(10),
        GLNUM VARCHAR(10),
        GLDESC_PRI varchar (100),
        GLDESC_SEC varchar (100),
        RRRRNUM VARCHAR(10),
        RRGROUP INT
    ) ON COMMIT DROP';

    EXECUTE '
    CREATE TEMP TABLE T_CP1  (
        CRNUM INT PRIMARY KEY,
        Paye DECIMAL
    ) ON COMMIT DROP';

    EXECUTE '
    CREATE TEMP TABLE T_RA  (
        RRNUM VARCHAR(10),
        RANUM INTEGER
    ) ON COMMIT DROP';

    EXECUTE '
    CREATE TEMP TABLE T_CR2  (
        CRNUM INT,
        CRMONT NUMERIC,
        CRDATE DATE,
        CRRRNUM VARCHAR(10),
        CRACNUM VARCHAR(10),
        Solde NUMERIC,
        GLNUM VARCHAR(10),
        GLDESC_PRI VARCHAR(100),
        GLDESC_SEC VARCHAR(100),
        RRRRNUM VARCHAR(10),
        RRGROUP INT
    ) ON COMMIT DROP';


     --  Sélection des infos des comptes à recevoir
     statement := ' INSERT INTO T_CR1 ( CRNUM, CRYPNUM, CRMONT, CRDATE,
CRRRNUM, CRACNUM,
                        GLNUM, GLDESC_PRI, GLDESC_SEC,
                        RRRRNUM,
                        RRGROUP)



----LOG-----------------
OG:  statement: select * from usp_Comptabilite_AgeDeCompteClient('M',
null, '2005-01-28', '1', '1', '0', null)
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
"t_rr_pkey" for table "t_rr"
CONTEXT:  SQL statement "

        CREATE TEMP TABLE T_RR  (

            RRNUM VARCHAR(10) PRIMARY KEY

        ) ON COMMIT DROP"
    PL/pgSQL function "usp_comptabilite_agedecompteclient" line 28 at
execute statement
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
"t_cr1_pkey" for table "t_cr1"
CONTEXT:  SQL statement "

        CREATE TEMP TABLE T_CR1  (

            CRNUM INT PRIMARY KEY,

            CRYPNUM VARCHAR(10),

            CRMONT DECIMAL,

            CRDATE DATE,

            CRRRNUM VARCHAR(10),

            CRACNUM VARCHAR(10),

            GLNUM VARCHAR(10),

            GLDESC_PRI varchar (100),

            GLDESC_SEC varchar (100),

            RRRRNUM VARCHAR(10),

            RRGROUP INT

        ) ON COMMIT DROP"
    PL/pgSQL function "usp_comptabilite_agedecompteclient" line 33 at
execute statement
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
"t_cp1_pkey" for table "t_cp1"
CONTEXT:  SQL statement "

        CREATE TEMP TABLE T_CP1  (

            CRNUM INT PRIMARY KEY,

            Paye DECIMAL

        ) ON COMMIT DROP"
    PL/pgSQL function "usp_comptabilite_agedecompteclient" line 48 at
execute statement