Prepared statement and pgbouncer

[Palaniappan Thiyagarajan <pthiyagarajan@xxxxxxxxxxxx>]

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