Postgres Pro
Downloads
Home   >   mailing lists

Prepared statement and pgbouncer - Mailing list pgsql-admin

From Palaniappan Thiyagarajan
Subject Prepared statement and pgbouncer
Date
Msg-id 3C9790592B997E43B4D5FC3DBAFD177B15C3415901@MBX13.EXCHPROD.USA.NET
Whole thread Raw
In response to newer release branch  (Marc Fromm <Marc.Fromm@wwu.edu>)
Responses Re: Prepared statement and pgbouncer
List pgsql-admin
Tree view

All,

 

We are experiencing prepared statement error in our application using pgbouncer/PostgreSQL 8.3

 

org.postgresql.util.PSQLException: ERROR: prepared statement "S_1"
already exists
at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1525)
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1309)
at

 

We don’t want to touch anything on application and we would like to overcome this issue by tuning pgbouncer or postgres.

 

Any pointer to this problem will be appreciated.

 

Thanks in advance

Palani

 

pgsql-admin by date:

Previous
From: A J
Date:
Subject: Restore rather than rebuild index ?
Next
From: "Kevin Grittner"
Date:
Subject: Re: Restore rather than rebuild index ?