[petereisentraut]

Feature author here. Running not-allowed-in-transaction-block DDL, such as VACUUM, still won't work in stored procedures. Room for future improvement.

[cryptonector]

I use DO for this sort of thing.

[petereisentraut]

You also cannot run VACUUM inside a DO block. It's the same thing underneath.

[cryptonector]

No, but I use it for the sort of DDL that's missing IF [NOT] EXISTS syntax.