Re: Prepared statement issue in Pgpool-II

Поиск
Список
Период
Сортировка
От raghu ram
Тема Re: Prepared statement issue in Pgpool-II
Дата
Msg-id AANLkTikez6YPtvCC7zMXaD89JrrK1IdeBHfvPpc6HFKN@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Prepared statement issue in Pgpool-II  (Vibhor Kumar <vibhor.kumar@enterprisedb.com>)
Список pgsql-novice


On Tue, Jun 29, 2010 at 3:25 PM, Vibhor Kumar <vibhor.kumar@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


В списке pgsql-novice по дате отправления:

Предыдущее
От: Vibhor Kumar
Дата:
Сообщение: Re: Prepared statement issue in Pgpool-II
Следующее
От: Greg
Дата:
Сообщение: Re: Postgre Protocol