Error OID

Hi all,

I have a big table:

CREATE TABLE Jurnal (Rekening Char(4) NOT NULL,  Debet Numeric(9) NOT
NULL,  Kredit Numeric(9) NOT NULL)
INSERT INTO Jurnal (Rekening,Debet,Kredit) values ('0001',1,2);
INSERT INTO Jurnal (Rekening,Debet,Kredit) values ('0002',3,4);



I create a function:

CREATE OR REPLACE FUNCTION ReProses()
RETURNS BOOLEAN
AS $$

DECLAREnHasil    Numeric;

BEGIN      CREATE TEMP TABLE tmpTtlRekening WITHOUT OIDS ON COMMIT DROP          AS      SELECT Rekening, SUM(Debet) AS
Debet,SUM(Kredit) AS Kredit        FROM Jurnal GROUP BY Rekening;
 
      SELECT COALESCE(SUM(Debet - Kredit), 0)        INTO nHasil        FROM tmpTtlRekening;
        -- bla,bla        RETURN '1';
END;
$$ LANGUAGE 'plpgsql';


Execute Query:

SELECT ReProses()

Result is fine, but when i execute again

SELECT ReProses()

ERROR: relation with OID 41573 does not exist



Can anyone help me

thanks