On Jun 29, 2006, at 5:58 PM, Tim Hart wrote:
> I'm coming in a bit late to this conversation, so forgive me if
> I've missed
> something. Isn't this problem the reason that connection pools were
> created?
>
> In a connection pool, connections are only associated with a
> particular
> user for the duration of a transaction. Once the transaction is
> complete,
> the connection goes back to the pool.
Right, this is standard operating procedure. But the original poster
mentioned tying the connection to a particular web user/session. In
other words, one connection per user.
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL