-
-
Notifications
You must be signed in to change notification settings - Fork 4.3k
Closed
Labels
dialect: postgresFor issues and PRs. Things that involve PostgreSQL (and do not involve all dialects).For issues and PRs. Things that involve PostgreSQL (and do not involve all dialects).type: featureDEPRECATED: replace with the "feature" issue typeDEPRECATED: replace with the "feature" issue type
Description
I have noticed that sequelize does not support "SKIP LOCKED" selects.
A query example with "FOR UPDATE" and "SKIP LOCKED" would be
SELECT "id" FROM "Customers" WHERE "Customers"."AccountBalance" > 5 LIMIT 3 FOR UPDATE SKIP LOCKED;
"SKIP LOCKED" is useful for job queues.
https://www.postgresql.org/docs/9.5/static/sql-select.html#SQL-FOR-UPDATE-SHARE
yocontra and hytromo
Metadata
Metadata
Assignees
Labels
dialect: postgresFor issues and PRs. Things that involve PostgreSQL (and do not involve all dialects).For issues and PRs. Things that involve PostgreSQL (and do not involve all dialects).type: featureDEPRECATED: replace with the "feature" issue typeDEPRECATED: replace with the "feature" issue type