Received: from localhost (uranus.hub.org [200.46.204.60]) by postgresql.org (Postfix) with ESMTP id D67759F9FB1 for ; Fri, 17 Nov 2006 07:07:22 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.60]) (amavisd-new, port 10024) with ESMTP id 85422-03 for ; Fri, 17 Nov 2006 07:07:20 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from moutng.kundenserver.de (moutng.kundenserver.de [212.227.126.186]) by postgresql.org (Postfix) with ESMTP id D72A99F9AD7 for ; Fri, 17 Nov 2006 07:07:19 -0400 (AST) Received: from [194.25.154.138] (helo=webserv.wug.de) by mrelayeu.kundenserver.de (node=mrelayeu6) with ESMTP (Nemesis), id 0ML29c-1Gl1Yz2Jpk-0008Tq; Fri, 17 Nov 2006 12:07:17 +0100 Received: from kretschmer by webserv.wug.de with local (Exim 3.36 #1) id 1Gl1Yy-0001ZG-00 for pgsql-sql@postgresql.org; Fri, 17 Nov 2006 12:07:16 +0100 Date: Fri, 17 Nov 2006 12:07:16 +0100 From: "A. Kretschmer" To: pgsql-sql@postgresql.org Subject: Re: hi may i know y am i getting this error Message-ID: <20061117110716.GH30411@a-kretschmer.de> References: Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: X-OS: Debian/GNU Linux - weil ich es mir Wert bin! X-Message-Flag: "Windows" is not the answer. "Windows" is the question and the answer is "no"! User-Agent: Mutt/1.5.9i X-Provags-ID: kundenserver.de abuse@kundenserver.de login:51ea9561fc3f6d9539a2acd743e4748c X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200611/183 X-Sequence-Number: 26835 am Fri, dem 17.11.2006, um 15:15:25 +0530 mailte Penchalaiah P. folgendes: > Hi > > When I am executing my function its giving error.. first time its running > properly.. but when I am executing second time I am getting error > > create or replace function irla_punching_medium_insert1(in_proj_code > numeric,in_pt_code varchar,in_mon_abs date) returns varchar as' > ... > > create table dummy_table without oids as > > ... > > drop table dummy_table; > end; > > 'language'plpgsql'; PG caches the plan for this function and runs in an error, because it believes the second time, that this table has the oid from the first run. You can rewrite your function and use EXECUTE for such statements (create and drop table). This might be helpful, but i'm not sure. Andreas -- Andreas Kretschmer Kontakt: Heynitz: 035242/47215, D1: 0160/7141639 (mehr: -> Header) GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net