[SQL] Error OID

[Yohanes Purnomo]

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 $$

DECLARE
        nHasil  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


---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

               http://archives.postgresql.org