Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-jdbc by date

Next:From: Josh BerkusDate: 2007-09-30 15:39:00
Subject: Re: Prepared Statements vs. pgbouncer
Previous:From: Paul LindnerDate: 2007-09-30 07:07:25
Subject: Re: Prepared Statements vs. pgbouncer

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group