Re: Implementing RESET CONNECTION ...

Oliver Jowett <oliver@opencloud.com>

From: Oliver Jowett <oliver@opencloud.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Kris Jurka <books@ejurka.com>, Hans-Jürgen Schönig <postgres@cybertec.at>, eg@cybertec.at, pgsql-patches@postgresql.org
Date: 2005-01-04T01:33:09Z
Lists: pgsql-hackers
Tom Lane wrote:

> Fair point, but you could make the same argument against *any* side
> effect of RESET CONNECTION.  You're just complaining about PREPARE
> because you can see immediately where that breaks JDBC.  Anything that
> any driver does to set up per-connection state the way it wants will
> be equally vulnerable.

Yes, exactly.

> Perhaps RESET CONNECTION should be a protocol-level operation instead
> of a SQL command?  That would prevent user-level code from causing it
> without the driver knowing.

I just suggested as much in another email (our emails crossed).

-O