Re: RESET CONNECTION?

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
Cc: Mario Weilguni <mweilguni(at)sime(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: RESET CONNECTION?
Date: 2006-07-19 15:43:56
Message-ID: 200607191543.k6JFhub25414@momjian.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

--
Bruce Momjian bruce(at)momjian(dot)us
EnterpriseDB http://www.enterprisedb.com

+ If your life is a hard drive, Christ can be your backup. +

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2006-07-19 15:44:34 Re: RESET CONNECTION?
Previous Message Jim C. Nasby 2006-07-19 15:35:42 Re: poor performance with Context Switch Storm at TPC-W.