summaryrefslogtreecommitdiff
path: root/src/sql/markEntityRetried.sql
diff options
context:
space:
mode:
Diffstat (limited to 'src/sql/markEntityRetried.sql')
-rw-r--r--src/sql/markEntityRetried.sql6
1 files changed, 6 insertions, 0 deletions
diff --git a/src/sql/markEntityRetried.sql b/src/sql/markEntityRetried.sql
new file mode 100644
index 0000000..6ec2263
--- /dev/null
+++ b/src/sql/markEntityRetried.sql
@@ -0,0 +1,6 @@
+UPDATE
+ entities
+SET
+ detail = jsonb_build_object('retriedAt', CURRENT_TIMESTAMP at time zone 'utc', 'error', ?::text)
+WHERE
+ id = ?