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