On 2/3/22 3: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 |ER
Can't you use a do script to construct and execute the statement?
>
On Thu, Feb 3, 2022 at 2: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
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 |ER
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 "\" .
Since vacuu
