Re: Prepared statement issue in Pgpool-II

On Tue, Jun 29, 2010 at 3:23 PM, Vibhor Kumar <vibhor(dot)kumar(at)enterprisedb(dot)com
> wrote:

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