On 2/3/22 1:29 PM, saket bansal wrote:
Hi, I am trying to schedule pg_cron to generate a set of commands and
then run them. E.g |select 'vacuum freeze '||table_name from
inventory_for_vacuum \gexec| . This works well at command line, but when
scheduled in pg_cron, it fails with syntax error |ERROR: syntax error at
or near "\"| .
\gexec is a psql metacommand and will only run in that client.
I'm guessing that is not the case in the pg_cron task?
Since vacuum doesn't work inside a transaction block |ERROR: VACUUM
cannot run inside a transaction block|, I cannot use a function directly
to run over a loop.
Any guidance to make it work or an alternative?
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
