Re: RESET CONNECTION? - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: RESET CONNECTION?
Date
Msg-id 200607250145.k6P1jSk00189@momjian.us
Whole thread Raw
In response to Re: RESET CONNECTION?  (Tatsuo Ishii <ishii@sraoss.co.jp>)
List pgsql-hackers
Tatsuo Ishii wrote:
> > Alvaro Herrera wrote:
> > > Bruce Momjian wrote:
> > > > Mario Weilguni wrote:
> > > > > Will this patch make it into 8.2?
> > > > > http://archives.postgresql.org/pgsql-patches/2004-12/msg00228.php
> > > > > 
> > > > > It's a really nice feature, would be extremly useful with tools like pgpool.
> > > > 
> > > > No, it will not because RESET CONNECTION can mess up interface code that
> > > > doesn't want the connection reset.  We are not sure how to handle that.
> > > 
> > > Hmm, what interface code are you talking about?
> > 
> > I believe JDBC, for example, sets things inside the interface that would
> > be broken by RESET CONNECTION.  Here is a thread about it:
> > 
> >     http://archives.postgresql.org/pgsql-patches/2005-01/msg00029.php
> 
> I think we had similar problem with client encoding and solved it by
> using parameter status. Why don't we solve the JDBC problem in the
> same way?

Oh, yes, we could do that.

--  Bruce Momjian   bruce@momjian.us EnterpriseDB    http://www.enterprisedb.com
 + If your life is a hard drive, Christ can be your backup. +


pgsql-hackers by date:

Previous
From: David Fetter
Date:
Subject: Re: Units in postgresql.conf -- How to report?
Next
From: "Jie Zhang"
Date:
Subject: Re: On-disk bitmap index patch