Am 27.07.2018 um 11:41 schrieb komala pelleti:
> Hi,
>
> We are using postgres 9.5.
>
> Iam not able to call vaccumdb from functions.: function check for
> tables for databse if pct_dead > 100, then we are issuing a vaccum on
> that table.
>
> getting error .
>
vacuum can't run inside a transaction, and a function is a transaction.
Why not using the autovacuum-feature?
Regards, Andreas
--
2ndQuadrant - The PostgreSQL Support Company.
www.2ndQuadrant.com