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