Skip to content

"SKIP LOCKED" support (request) #8910

@themetalfleece

Description

@themetalfleece

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

Metadata

Metadata

Assignees

No one assigned

    Labels

    dialect: postgresFor issues and PRs. Things that involve PostgreSQL (and do not involve all dialects).type: featureDEPRECATED: replace with the "feature" issue type

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions