Message-ID: <1254.222.124.95.13.1196821462.squirrel@email.powweb.com>
Date: Tue, 4 Dec 2007 21:24:22 -0500 (EST)
Subject: Error OID
From: "Yohanes Purnomo" <yohanes@logicsoftware.info>
To: pgsql-sql@postgresql.org
Reply-To: yohanes@logicsoftware.info
User-Agent: SquirrelMail/1.4.9a
MIME-Version: 1.0
Content-Type: text/plain;charset=iso-8859-1
Content-Transfer-Encoding: 8bit
Importance: Normal

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