6 ms·
Do you add jobs inside a transaction? Or with a root connection? There doesn't seem to be an out of the box way to add jobs in a transaction.
by brycelarkin 2y ago
Do you add jobs inside a transaction? Or with a root connection? There doesn't seem to be an out of the box way to add jobs in a transaction.
- philefstat 2y agoyes you can add jobs with sql in a transaction, e.g. SELECT graphile_worker.add_job( 'send_email', json_build_object( 'to', 'someone@example.com', 'subject', 'graphile-worker test' ) ); (can also use the PERFORM statement instead of SELECT)