Re: SET AUTOCOMMIT TO OFF no longer supported

Carlos Correia <carlos(at)m16e(dot)com> writes:
> Tom Lane escreveu:
> | I think you need a newer JDBC driver. (If the app itself, rather than
> | the driver, is trying to issue this command then the app is so broken
> | it doesn't deserve to live.)

> newer then this:
> http://jdbc.postgresql.org/download/postgresql-8.1-404.jdbc3.jar?

No, that driver is plenty new enough to know not to do this. It's the
app that's broken, then --- it has no business messing with SET
AUTOCOMMIT rather than using the JDBC-spec methods to control
transaction boundaries.

> | It might have worked with 7.3, but 7.4 would give this same error message.

> Well, as I said before, it's been working perfectly from several years
> with 7.4.

Interesting. Maybe the app is coded to use SET AUTOCOMMIT only with 7.3
(which is the *only* PG release series that ever had this command),
but its version test is broken so that it tries to use it with 8.*?

regards, tom lane