Re: [SQL] Error OID

2007-12-05 Thread Yohanes Purnomo
Guillaume Lelarge write: > When you run a function for the first time in the session, PostgreSQL > keeps in cache some information... query plans for example. > > > When you run it a second time, it uses the query plan in cache. As > tmpTtlRekening has been drop at the end of the first run, its OI

Re: [SQL] Error OID

2007-12-04 Thread Guillaume Lelarge
Yohanes Purnomo a écrit : > [...] > 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 D