Re: Implementing RESET CONNECTION ...

On Tue, 4 Jan 2005, [ISO-8859-1] Hans-Jrgen Schnig wrote:

> I completely agree with Karel. I think it is a bad idea to change the
> protocol for such a minor feature - i tend to call it overkill.

I agree. I don't think it's imperative to prevent or detect this
condition. The only real caller of this should be the driver itself. If
the end user does call this and breaks things I wouldn't consider it our
problem. Making this available at the protocol level only would certainly
solve that, but it's not really compelling to make a protocol level jump.

> I want to add one point to this discussion: There is not just JDBC -
> other connection pools or clients might want different behaviour (which
> can from my point of view only lead to a complete reset).

Right, I am speaking from the JDBC driver perspective, but I think any
higher level interface should desire to do statement pooling, which will
have this problem. You have not stated what client interface you are
targetting, but I believe anything written to a higher level than libpq
will need to be aware of this. Perhaps -patches isn't the right place to
solicit input for this.

Kris Jurka