Do you add jobs inside a transaction? Or with a root connection? There doesn't s... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

		brycelarkin on May 10, 2024 \| parent \| context \| favorite \| on: Show HN: An SQS Alternative on Postgres 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 on May 10, 2024 [–]

yes 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)

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact