diff options
| author | benj <benj@rse8.com> | 2022-12-29 00:09:27 -0800 |
|---|---|---|
| committer | benj <benj@rse8.com> | 2022-12-29 00:09:27 -0800 |
| commit | f0ea9ecd17b03605d747044874a26e1bd52c0ee1 (patch) | |
| tree | c42b94f530ab64dad19eecdfefc9aa53c08f3097 /crates/secd/store/pg/sql/write_session.sql | |
| parent | c2268c285648ef02ece04de0d9df0813c6d70ff8 (diff) | |
| download | secdiam-f0ea9ecd17b03605d747044874a26e1bd52c0ee1.tar secdiam-f0ea9ecd17b03605d747044874a26e1bd52c0ee1.tar.gz secdiam-f0ea9ecd17b03605d747044874a26e1bd52c0ee1.tar.bz2 secdiam-f0ea9ecd17b03605d747044874a26e1bd52c0ee1.tar.lz secdiam-f0ea9ecd17b03605d747044874a26e1bd52c0ee1.tar.xz secdiam-f0ea9ecd17b03605d747044874a26e1bd52c0ee1.tar.zst secdiam-f0ea9ecd17b03605d747044874a26e1bd52c0ee1.zip | |
revoke session (+ some cleanup)
Diffstat (limited to '')
| -rw-r--r-- | crates/secd/store/pg/sql/write_session.sql | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/crates/secd/store/pg/sql/write_session.sql b/crates/secd/store/pg/sql/write_session.sql index 18dc1f1..aa9c0a1 100644 --- a/crates/secd/store/pg/sql/write_session.sql +++ b/crates/secd/store/pg/sql/write_session.sql @@ -7,4 +7,5 @@ insert into secd.session ( ) values ( (select identity_id from secd.identity where identity_public_id = $1) , $2, $3, $4, $5 -); +) on conflict (token_hash) do update + set revoked_at = excluded.revoked_at; |