Re: SET AUTOCOMMIT TO OFF no longer supported

Carlos Correia <carlos@m16e.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