Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 308BE633337 for ; Tue, 29 Jun 2010 02:23:00 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 63787-10 for ; Tue, 29 Jun 2010 05:22:52 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from exprod7og102.obsmtp.com (exprod7og102.obsmtp.com [64.18.2.157]) by mail.postgresql.org (Postfix) with SMTP id A1AA5632A35 for ; Tue, 29 Jun 2010 02:22:52 -0300 (ADT) Received: from source ([209.85.214.178]) by exprod7ob102.postini.com ([64.18.6.12]) with SMTP ID DSNKTCmDKmngQd6QrUdaDFcJRWFJcjH67vH3@postini.com; Mon, 28 Jun 2010 22:22:52 PDT Received: by iwn41 with SMTP id 41so943047iwn.9 for ; Mon, 28 Jun 2010 22:22:50 -0700 (PDT) Received: by 10.231.123.215 with SMTP id q23mr6581678ibr.190.1277788970510; Mon, 28 Jun 2010 22:22:50 -0700 (PDT) Received: from Vibhor-Kumars-MacBook-Pro.local ([117.195.2.121]) by mx.google.com with ESMTPS id g8sm12741944ibb.23.2010.06.28.22.22.46 (version=SSLv3 cipher=RC4-MD5); Mon, 28 Jun 2010 22:22:49 -0700 (PDT) Message-ID: <4C29C281.40906@enterprisedb.com> Date: Tue, 29 Jun 2010 10:53:05 +0100 From: Vibhor Kumar Organization: EnterpriseDB Corporation User-Agent: Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.6; en-US; rv:1.9.1.10) Gecko/20100512 Lightning/1.0b1 Thunderbird/3.0.5 MIME-Version: 1.0 To: raghu ram CC: pgsql-general@postgresql.org Subject: Re: Prepared statement issue in Pgpool-II References: In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.173 tagged_above=-5 required=5 tests=BAYES_00=-1.9, DATE_IN_FUTURE_03_06=3.027, RCVD_IN_DNSWL_MED=-2.3 X-Spam-Level: X-Archive-Number: 201006/1242 X-Sequence-Number: 164779 On 28/06/10 11:14 PM, raghu ram wrote: > > Hi, > > > > We are using pgool-II version 2.3.2.2 (tomiteboshi)and postgres 8.3.9 > and facing the below error while running the select queries in the > application side:: > > > ERROR: prepared statement > "mdb2_statement_pgsql_71417ca02c1aa9cec1dd2570c46e992e" does not exist > Try with reset_query_list= 'ABORT; DISCARD ALL' -- Thanks& Regards, Vibhor Kumar. EnterpriseDB Corporation The Enterprise Postgres Company Office: 732-331-1300 Ext-2022 Website: www.enterprisedb.com EnterpriseDB Blog: http://blogs.enterprisedb.com Follow us on Twitter: http://www.twitter.com/enterprisedb