Large Objects may not be used in auto-commit mode
A large object can be stored in several records, that’s why you have to use a transaction. All records are correct or nothing at all. https://www.postgresql.org/docs/current/static/largeobjects.html
autocommit
How do you set autocommit in an SQL Server session?
You can turn autocommit ON by setting implicit_transactions OFF: SET IMPLICIT_TRANSACTIONS OFF When the setting is ON, it returns to implicit transaction mode. In implicit transaction mode, every change you make starts a transactions which you have to commit manually. Maybe an example is clearer. This will write a change to the database: SET IMPLICIT_TRANSACTIONS … Read more