pg_cron failing when using transaction block

Question

I have a query as a transaction, using BEGIN and COMMIT. When I run this as a query it succeeds, however when I run it through pg_cron I receive the following error:

FATAL: EndTransactionBlock: unexpected state BEGIN

BEGIN;TRUNCATE app_top50;INSERT INTO xxx...;COMMIT;

Googling the error returns very few results.

Answer 1

pg_cron source code has a comment about it:

/*
 * We don't allow transaction-control commands like COMMIT and ABORT
 * here.  The entire SQL statement is executed as a single transaction
 * which commits if no errors are encountered.
*/

So you don't need to add BEGIN; ... COMMIT; block. Just add queries and they will be executed as single transaction.