Skip to content

Instantly share code, notes, and snippets.

@peterbe

peterbe/test.sql

Created March 3, 2017 14:52
Show Gist options
  • Save peterbe/20cef3468192fc08628073cb7070ccb8 to your computer and use it in GitHub Desktop.
Save peterbe/20cef3468192fc08628073cb7070ccb8 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
test.sql
BEGIN;
SELECT ongoing FROM crontabber WHERE app_name = 'bar'
FOR UPDATE NOWAIT;
select pg_sleep(random() * 10);
UPDATE crontabber SET ongoing = now() WHERE app_name = 'bar';
COMMIT;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment