Error OID

From: "Yohanes Purnomo" <yohanes(at)logicsoftware(dot)info>
To: pgsql-sql(at)postgresql(dot)org
Subject: Error OID
Date: 2007-12-05 02:24:22
Message-ID: 1254.222.124.95.13.1196821462.squirrel@email.powweb.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Guillaume Lelarge 2007-12-05 07:36:15 Re: Error OID
Previous Message Ehab Galal 2007-12-04 22:25:09 marking tuples