On Tue, Jun 29, 2010 at 3:25 PM, Vibhor Kumar <vibhor.ku...@enterprisedb.com
> wrote:

> 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 Vibhor...

If you set the  reset_query_list = 'ABORT; DISCARD ALL'
 (or) reset_query_list = 'ABORT; DISCARD TEMPORARY' also getting the same
error again for both version of the Pgpool-II.


Thanks&Regards
Raghu


-- 
> 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
>
>

Reply via email to