diff options
Diffstat (limited to 'crates/secd/store/pg/sql/write_credential.sql')
| -rw-r--r-- | crates/secd/store/pg/sql/write_credential.sql | 4 |
1 files changed, 3 insertions, 1 deletions
diff --git a/crates/secd/store/pg/sql/write_credential.sql b/crates/secd/store/pg/sql/write_credential.sql index 17e03a2..ecaf523 100644 --- a/crates/secd/store/pg/sql/write_credential.sql +++ b/crates/secd/store/pg/sql/write_credential.sql @@ -16,4 +16,6 @@ insert into secd.credential ( , $6 , $7 , $8 -); +) on conflict (partial_key) do update + set revoked_at = excluded.revoked_at + , deleted_at = excluded.deleted_at; |