Received: from localhost (unknown [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id F20932E0247 for ; Wed, 5 Dec 2007 22:09:16 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 37162-04 for ; Wed, 5 Dec 2007 22:09:02 -0400 (AST) Received: from mailout09.yourhostingaccount.com (mailout09.yourhostingaccount.com [65.254.253.74]) by postgresql.org (Postfix) with ESMTP id 78CDD2E0212 for ; Wed, 5 Dec 2007 22:09:13 -0400 (AST) Received: from mailscan18.yourhostingaccount.com ([10.1.15.18] helo=mailscan18.yourhostingaccount.com) by mailout09.yourhostingaccount.com with esmtp (Exim) id 1J06Ap-0001J6-SY for pgsql-sql@postgresql.org; Wed, 05 Dec 2007 21:09:11 -0500 Received: from impout02.yourhostingaccount.com ([10.1.55.2] helo=impout02.yourhostingaccount.com) by mailscan18.yourhostingaccount.com with esmtp (Exim) id 1J06Ap-0003Tp-Kx for pgsql-sql@postgresql.org; Wed, 05 Dec 2007 21:09:11 -0500 Received: from webmail11.yourhostingaccount.com ([10.1.16.11]) by impout02.yourhostingaccount.com with NO UCE id ME9A1Y00B0EKF3e0000100; Wed, 05 Dec 2007 21:09:11 -0500 X-EN-OrigOutIP: 10.1.16.11 X-EN-IMPSID: ME9A1Y00B0EKF3e0000100 Received: from nobody by webmail11.yourhostingaccount.com with local (Exim) id 1J06AQ-0000A7-Kx for pgsql-sql@postgresql.org; Wed, 05 Dec 2007 21:08:46 -0500 Received: from 222.124.79.135 (SquirrelMail authenticated user yohanes@pop.powweb.com) by email.powweb.com with HTTP; Wed, 5 Dec 2007 21:08:46 -0500 (EST) Message-ID: <1112.222.124.79.135.1196906926.squirrel@email.powweb.com> In-Reply-To: <475654EF.8010804@lelarge.info> References: <1254.222.124.95.13.1196821462.squirrel@email.powweb.com> <475654EF.8010804@lelarge.info> Date: Wed, 5 Dec 2007 21:08:46 -0500 (EST) Subject: Re: Error OID From: "Yohanes Purnomo" 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 X-Priority: 3 (Normal) Importance: Normal X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.62 tagged_above=0 required=5 tests=AWL=0.619, BAYES_50=0.001 X-Spam-Level: X-Archive-Number: 200712/16 X-Sequence-Number: 29708 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 OID will > change but the old OID is still in cache. So PostgreSQL tries to get > information from the old temp table. > Guillaume Lelarge many thanks for your information Regards Yohanes Purnomo