diff options
Diffstat (limited to 'crates/secd/store/pg/sql/write_identity.sql')
| -rw-r--r-- | crates/secd/store/pg/sql/write_identity.sql | 4 |
1 files changed, 3 insertions, 1 deletions
diff --git a/crates/secd/store/pg/sql/write_identity.sql b/crates/secd/store/pg/sql/write_identity.sql index 7d53ee1..94a51fe 100644 --- a/crates/secd/store/pg/sql/write_identity.sql +++ b/crates/secd/store/pg/sql/write_identity.sql @@ -6,4 +6,6 @@ insert into secd.identity ( $1, $2, $3 -); +) on conflict(identity_public_id) do update + set data = excluded.data + , deleted_at = excluded.deleted_at; |