Postgres Pro
Downloads
Home   >   mailing lists

Re: Prepared statement issue in Pgpool-II - Mailing list pgsql-novice

From Vibhor Kumar
Subject Re: Prepared statement issue in Pgpool-II
Date
Msg-id 4C29C32E.8070303@enterprisedb.com
Whole thread Raw
In response to Prepared statement issue in Pgpool-II  (raghu ram <raghuchennuru@gmail.com>)
Responses Re: Prepared statement issue in Pgpool-II  (raghu ram <raghuchennuru@gmail.com>)
List pgsql-novice
Tree view 
On 28/06/10 10:32 PM, raghu ram wrote:
>
> ERROR:  prepared statement
> "mdb2_statement_pgsql_71417ca02c1aa9cec1dd2570c46e992e" does not exist
>
>  STATEMENT:  DEALLOCATE PREPARE
> mdb2_statement_pgsql_71417ca02c1aa9cec1dd2570c46e992e
>
>  WARNING:  archive_mode enabled, yet archive_command is not set
>
>
> In the pgpool.conf file set the  "reset_query_list" ='ABORT; RESET
> ALL; SET SESSION AUTHORIZATION DEFAULT'
>

Change the parameter setting reset_query_list = 'ABORT; DISCARD ALL'

--
Thanks&  Regards,
Vibhor Kumar.
Senior System Engineer.
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

pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: Postgre Protocol
Next
From: raghu ram
Date:
Subject: Re: Prepared statement issue in Pgpool-II