pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Vibhor Kumar <vibhor.kumar@enterprisedb.com>
To: raghu ram <raghuchennuru@gmail.com>
Cc: pgsql-admin@postgresql.org
Cc: pgsql-novice@postgresql.org
Cc: abbas.dba@gmail.com
Subject: Re: [NOVICE] Prepared statement issue in Pgpool-II
Date: Tue, 29 Jun 2010 10:55:58 +0100
Message-ID: <4C29C32E.8070303@enterprisedb.com> (raw)
In-Reply-To: <AANLkTimzp4L13V8PeQ2mCJY4565dpQ94buAbY85ZspkJ@mail.gmail.com>
References: <AANLkTimzp4L13V8PeQ2mCJY4565dpQ94buAbY85ZspkJ@mail.gmail.com>

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




view thread (6+ messages)

Message-ID: <4C29C32E.8070303@enterprisedb.com>
Permalink:  ../4C29C32E.8070303@enterprisedb.com/
Also on:    postgresql.org/message-id/4C29C32E.8070303@enterprisedb.com

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: vibhor.kumar@enterprisedb.com, raghuchennuru@gmail.com, pgsql-novice@postgresql.org, abbas.dba@gmail.com
  Subject: Re: [NOVICE] Prepared statement issue in Pgpool-II
  In-Reply-To: <4C29C32E.8070303@enterprisedb.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox