Corey Huinker wrote: > As of v11, DO blocks can do transactions. I think this will meet your needs.
They do support COMMIT and ROLLBACK in the current development tree, but not VACUUM as in Pierre's example. postgres=# \echo :SERVER_VERSION_NAME 11devel postgres=# do ' begin vacuum; end '; ERROR: VACUUM cannot be executed from a function CONTEXT: SQL statement "vacuum" PL/pgSQL function inline_code_block line 1 at SQL statement Best regards, -- Daniel Vérité PostgreSQL-powered mailer: http://www.manitou-mail.org Twitter: @DanielVerite
