RE: Row locks, SKIP LOCKED, and transactions
Steven Winfield <[email protected]> Wed, 18 Dec 2019 10:42:49 +0000
| Newsgroups | gmane.comp.db.postgresql.general |
|---|---|
| Message-ID | <E9FA92C2921F31408041863B74EE4C2001E7664F89@CCPMAILDAG03.cantab.local> |
>> * I observe this even if I crank up the transaction isolation level to repeatable read and serializable. >> >> >> I'm wondering if row locks are not obeying the same transactional semantics as row data, >Gotta believe it is this: > >https://www.postgresql.org/docs/11/transaction-iso.html#XACT-READ-COMMITTED > >"UPDATE, DELETE, SELECT FOR UPDATE, and SELECT FOR SHARE commands ..." > >If I read correctly, transactions can see the effects of other >transactions that commit during their lifetime. Thanks. I had a look at those docs when I first encountered the issue (if it can be called that), which prompted me to try repeatable read and serializable isolation levels, but to no avail. I couldn't find anything specifically mentioning the visibility of row locks at different isolation levels.