Re: Prepared Statements vs. pgbouncer

From: Oliver Jowett <oliver(at)opencloud(dot)com>
To: Paul Lindner <lindner(at)inuus(dot)com>
Cc: Gregory Stark <stark(at)enterprisedb(dot)com>, pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Prepared Statements vs. pgbouncer
Date: 2007-09-30 07:11:04
Message-ID: 46FF4C08.2090608@opencloud.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Paul Lindner wrote:

> 2) If we try to prepare a statement with an hashed name and it already
> exists then we ignore the error and continue.

Errors will cause the current transaction to fail..

> 3) If we receive an error while executing a prepared statement with an
> hashed name the driver will try to re-prepare the statement and
> re-execute the query. If an error occurs after this retry step then
> error are surfaced to the caller.

... so you can't just back off and try again.

-O

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Josh Berkus 2007-09-30 15:39:00 Re: Prepared Statements vs. pgbouncer
Previous Message Paul Lindner 2007-09-30 07:07:25 Re: Prepared Statements vs. pgbouncer