Context:
Support FOR UPDATE Of tablename SKIP LOCKED syntax:
Going to look at adding FOR x OF [tables] syntax to the rest of the locking kinds hence making this a draft (Plus updating to use the ( &: ) esqueleto style instead of an existential type
This allows a the FOR UPDATE SKIP LOCKED behaviour when you have a LEFT OUTER JOIN with a nullable side. Currently you will get the error:
FOR UPDATE cannot be applied to the nullable side of an outer join
The workaround currently using esqueleto is to do seperate queries and then join them manually if you want to select rows for an update while skipping locked rows (or to just do a raw query). I ran into this situation at work.
Context: Support
FOR UPDATE Of tablename SKIP LOCKED
syntax:Going to look at adding FOR x OF [tables] syntax to the rest of the locking kinds hence making this a draft (Plus updating to use the ( &: ) esqueleto style instead of an existential type
This allows a the
FOR UPDATE SKIP LOCKED
behaviour when you have aLEFT OUTER JOIN
with a nullable side. Currently you will get the error:The workaround currently using esqueleto is to do seperate queries and then join them manually if you want to select rows for an update while skipping locked rows (or to just do a raw query). I ran into this situation at work.
See: https://www.postgresql.org/docs/current/sql-select.html namely:
also documented in MySQL: https://dev.mysql.com/doc/refman/8.0/en/select.html
Usage example would be
@since
declarations to the Haddock.stylish-haskell
and otherwise adhered to the style guide.After submitting your PR: