pg_cron for vacuum - dynamic table set
| От | saket bansal |
|---|---|
| Тема | pg_cron for vacuum - dynamic table set |
| Дата | |
| Msg-id | CACkcRNiuyVkDJBEQg+u6sG=CA5-b73Jx1bzCVZO_dvacNfKMag@mail.gmail.com обсуждение исходный текст |
| Ответы |
Re: pg_cron for vacuum - dynamic table set
Re: pg_cron for vacuum - dynamic table set Re: pg_cron for vacuum - dynamic table set |
| Список | pgsql-general |
Hi, I am trying to schedule pg_cron to generate a set of commands and then run them. E.g
Since vacuum doesn't work inside a transaction block
Any guidance to make it work or an alternative?
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 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?
В списке pgsql-general по дате отправления: