Re: Prepared Statements vs. pgbouncer

[Gregory Stark <stark(at)enterprisedb(dot)com>]

"Paul Lindner" <lindner(at)inuus(dot)com> writes:

>   * pgbouncer notices that client A is idle and reassigns backend to 
>     client B

What do you mean by "notices"? 

Prepared statements are only one form of state which can persist beyond a
transaction end. I don't think you can reassign connections unless you get
some sort of explicit notice that the client is done with any state it has set
up. Either the driver supports noticing such a state because there are no
active references to its handle or the client issues a statement like RESET
ALL or something equivalent.

-- 
  Gregory Stark
  EnterpriseDB          http://www.enterprisedb.com