WITH HOLD and pooled connections

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: PostgreSQL-development <pgsql-hackers(at)postgreSQL(dot)org>
Subject: WITH HOLD and pooled connections
Date: 2003-08-08 17:36:08
Message-ID: 200308081736.h78Ha8L03083@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Seems we have a problem with pooled connections and WITH HOLD cursors.

We have code to reset transaction state and variables via RESET ALL, but
how do we remove WITH HOLD cursors when we pass a connection to a new
client?

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Joe Conway 2003-08-08 17:38:03 Re: TODO items
Previous Message Tom Lane 2003-08-08 17:26:17 Re: TODO items