Postgres Pro
Downloads
Home   >   mailing lists

Prepared statement issue in Pgpool-II - Mailing list pgsql-general

From raghu ram
Subject Prepared statement issue in Pgpool-II
Date
Msg-id AANLkTilIhn8hWGrxid5r5_ZTO9IGX3XeklCTv0Lkgag_@mail.gmail.com
Whole thread Raw
Responses Re: Prepared statement issue in Pgpool-II  (Vibhor Kumar <vibhor.kumar@enterprisedb.com>)
List pgsql-general
Tree view

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

 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'


We also tested on pgpool-II version 2.3.3, result will be same.


Please help us to resolve the issue.


Regards

Raghu


pgsql-general by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: weird initdb output
Next
From: Bruce Momjian
Date:
Subject: Re: The case of PostgreSQL on NFS Server