PG Bug reporting form <noreply@postgresql.org> writes:
> My system has numerous SQL scripts (each script contains multiple SQL
> statements). Many of them look like
> UPDATE ...
> INSERT ...
> ...
> VACUUM ...
> These scripts are being run from a Java program, with AutoCommit=true, via
> JDBC as:
Sorry, you'll have to fix your scripts to do that separately.
(It might be sufficient to add COMMIT before the VACUUM.)
It was a bug that we didn't enforce this requirement all along.
> The same SQL scripts are still working with the latest postgresql 14.7
I'm quite skeptical of that claim; I see the restriction being
enforced the same way in all supported branches.
regards, tom lane
