projects / evergreen-equinox.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 8495bbe) | patch
LP2011434 (follow-up): use NOT VALID / VALIDATE CONSTRAINT pattern to minimize lockin...
authorJane Sandberg <js7389@princeton.edu>
Tue, 9 May 2023 02:43:04 +0000 (19:43 -0700)
committerJane Sandberg <js7389@princeton.edu>
Tue, 9 May 2023 02:43:04 +0000 (19:43 -0700)
commit7f061a5e02bae1010a0a61199fc3f6529c7b5af9
tree074485149befead959511d9d22c1f9a2818a1d78tree | snapshot
parent8495bbe0f3e087b5ca7b68198d70e46c59edec76commit | diff
LP2011434 (follow-up): use NOT VALID / VALIDATE CONSTRAINT pattern to minimize locking on action.hold_request

Also simplify the WHERE clause in the UPDATE statement, making its intentions clearer to my eye at least

Signed-off-by: Jane Sandberg <js7389@princeton.edu>
Open-ILS/src/sql/Pg/upgrade/xxxx.schema.function-selection-ou-fkey.sql diff | blob | history
Evergreen with Equinox developments in process and local tweaks