Opened 8 years ago

Closed 8 years ago

#26500 closed New feature (fixed)

Implement select_for_update(skip_locked=True) for Postgresql and Oracle

Reported by: Simon Charette Owned by: Simon Charette
Component: Database layer (models, ORM) Version: dev
Severity: Normal Keywords:
Cc: Triage Stage: Ready for checkin
Has patch: yes Needs documentation: no
Needs tests: no Patch needs improvement: no
Easy pickings: no UI/UX: no

Description

PostgreSQL supports this feature since 9.5.

A ValueError should be raised if both nowait and skip_locked are True.

Change History (5)

comment:1 by Anssi Kääriäinen, 8 years ago

Triage Stage: Unreviewed → Accepted

comment:2 by Simon Charette, 8 years ago

Owner: changed from nobody to Simon Charette
Status: new → assigned

comment:3 by Simon Charette, 8 years ago

Has patch: set

​PR

comment:4 by Tim Graham, 8 years ago

Triage Stage: Accepted → Ready for checkin

comment:5 by Simon Charette <charette.s@…>, 8 years ago

Resolution: → fixed
Status: assigned → closed

In b8e6e1b4:

Fixed #26500 -- Added SKIP LOCKED support to select_for_update().

Thanks Tim for the review.

Note: See TracTickets for help on using tickets.
Back to Top