[Django] #26500: Implement select_for_update(skip_locked=True) for Postgresql and Oracle

[Django]

#26500: Implement select_for_update(skip_locked=True) for Postgresql and Oracle
-------------------------------------+-------------------------------------
Reporter: charettes | Owner: nobody
Type: New | Status: new
feature |
Component: Database | Version: master
layer (models, ORM) |
Severity: Normal | Keywords:
Triage Stage: | Has patch: 0
Unreviewed |
Needs documentation: 0 | Needs tests: 0
Patch needs improvement: 0 | Easy pickings: 0
UI/UX: 0 |
-------------------------------------+-------------------------------------
PostgreSQL supports this feature since 9.5.

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

--
Ticket URL: <https://code.djangoproject.com/ticket/26500>
Django <https://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.

[Django]

#26500: Implement select_for_update(skip_locked=True) for Postgresql and Oracle
-------------------------------------+-------------------------------------
Reporter: charettes | Owner: nobody

Type: New feature | Status: new
Component: Database layer | Version: master
(models, ORM) |
Severity: Normal | Resolution:
Keywords: | Triage Stage: Accepted
Has patch: 0 | Needs documentation: 0

Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------

Changes (by akaariai):

* stage: Unreviewed => Accepted

--
Ticket URL: <https://code.djangoproject.com/ticket/26500#comment:1>

[Django]

#26500: Implement select_for_update(skip_locked=True) for Postgresql and Oracle
-------------------------------------+-------------------------------------

Reporter: charettes | Owner: charettes
Type: New feature | Status: assigned

Component: Database layer | Version: master
(models, ORM) |
Severity: Normal | Resolution:
Keywords: | Triage Stage: Accepted

Has patch: 0 | Needs documentation: 0

Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------

Changes (by charettes):

* status: new => assigned
* owner: nobody => charettes

--
Ticket URL: <https://code.djangoproject.com/ticket/26500#comment:2>

[Django]

#26500: Implement select_for_update(skip_locked=True) for Postgresql and Oracle
-------------------------------------+-------------------------------------

Reporter: charettes | Owner: charettes
Type: New feature | Status: assigned
Component: Database layer | Version: master
(models, ORM) |
Severity: Normal | Resolution:
Keywords: | Triage Stage: Accepted

Has patch: 1 | Needs documentation: 0

Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------

Changes (by charettes):

* has_patch: 0 => 1

Comment:

[https://github.com/django/django/pull/7015 PR]

--
Ticket URL: <https://code.djangoproject.com/ticket/26500#comment:3>

[Django]

#26500: Implement select_for_update(skip_locked=True) for Postgresql and Oracle
-------------------------------------+-------------------------------------

Reporter: charettes | Owner: charettes
Type: New feature | Status: assigned
Component: Database layer | Version: master
(models, ORM) |
Severity: Normal | Resolution:

Keywords: | Triage Stage: Ready for
| checkin
Has patch: 1 | Needs documentation: 0

Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------

Changes (by timgraham):

* stage: Accepted => Ready for checkin

--
Ticket URL: <https://code.djangoproject.com/ticket/26500#comment:4>

[Django]

#26500: Implement select_for_update(skip_locked=True) for Postgresql and Oracle
-------------------------------------+-------------------------------------

Reporter: charettes | Owner: charettes
Type: New feature | Status: closed

Component: Database layer | Version: master
(models, ORM) |

Severity: Normal | Resolution: fixed

Keywords: | Triage Stage: Ready for
| checkin

Has patch: 1 | Needs documentation: 0

Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------

Changes (by Simon Charette <charette.s@…>):

* status: assigned => closed
* resolution: => fixed

Comment:

In [changeset:"b8e6e1b43b0bccec178dcc6708c5c8295abfb2e5" b8e6e1b4]:
{{{
#!CommitTicketReference repository=""
revision="b8e6e1b43b0bccec178dcc6708c5c8295abfb2e5"
Fixed #26500 -- Added SKIP LOCKED support to select_for_update().

Thanks Tim for the review.
}}}

--
Ticket URL: <https://code.djangoproject.com/ticket/26500#comment:5>