Re: [Django] #32943: Add support for covering indexes and exclusion constraints for SP-GiST in PostgreSQL 14+.

Django

unread,

Oct 1, 2021, 1:49:36 AM10/1/21

to django-...@googlegroups.com

#32943: Add support for covering indexes and exclusion constraints for SP-GiST in
PostgreSQL 14+.
-------------------------------------+-------------------------------------
Reporter: Nick Pope | Owner: Nick Pope
Type: New feature | Status: assigned
Component: contrib.postgres | Version: dev
Severity: Normal | Resolution:
Keywords: postgresql, spgist, | Triage Stage: Accepted
index, exclusion, constraint, |
include, covering |
Has patch: 1 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Changes (by Mariusz Felisiak):

* stage: Someday/Maybe => Accepted

Comment:

PostgreSQL 14 is [https://www.postgresql.org/docs/14/release-14.html
released].

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

Django

unread,

Oct 1, 2021, 6:49:53 AM10/1/21

to django-...@googlegroups.com

#32943: Add support for covering indexes and exclusion constraints for SP-GiST in
PostgreSQL 14+.
-------------------------------------+-------------------------------------
Reporter: Nick Pope | Owner: Nick Pope
Type: New feature | Status: assigned
Component: contrib.postgres | Version: dev
Severity: Normal | Resolution:

Keywords: postgresql, spgist, | Triage Stage: Ready for
index, exclusion, constraint, | checkin

include, covering |
Has patch: 1 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Changes (by Mariusz Felisiak):

* stage: Accepted => Ready for checkin

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

Django

unread,

Oct 1, 2021, 7:45:37 AM10/1/21

to django-...@googlegroups.com

#32943: Add support for covering indexes and exclusion constraints for SP-GiST in
PostgreSQL 14+.
-------------------------------------+-------------------------------------
Reporter: Nick Pope | Owner: Nick Pope
Type: New feature | Status: assigned
Component: contrib.postgres | Version: dev
Severity: Normal | Resolution:
Keywords: postgresql, spgist, | Triage Stage: Ready for
index, exclusion, constraint, | checkin
include, covering |
Has patch: 1 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------

Comment (by Mariusz Felisiak <felisiak.mariusz@…>):

In [changeset:"e76f9d5b443845639262e18d9020ef4b070f1c7d" e76f9d5]:
{{{
#!CommitTicketReference repository=""
revision="e76f9d5b443845639262e18d9020ef4b070f1c7d"
Refs #32943 -- Added support for covering SP-GiST indexes on PostgreSQL
14+.
}}}

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

Django

unread,

Oct 1, 2021, 7:45:37 AM10/1/21

to django-...@googlegroups.com

#32943: Add support for covering indexes and exclusion constraints for SP-GiST in
PostgreSQL 14+.
-------------------------------------+-------------------------------------
Reporter: Nick Pope | Owner: Nick Pope
Type: New feature | Status: assigned
Component: contrib.postgres | Version: dev
Severity: Normal | Resolution:
Keywords: postgresql, spgist, | Triage Stage: Ready for
index, exclusion, constraint, | checkin
include, covering |
Has patch: 1 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------

Comment (by Mariusz Felisiak <felisiak.mariusz@…>):

In [changeset:"c2f6c05c4cc73e831b7e852eb58bd6d7a83fa46c" c2f6c05c]:
{{{
#!CommitTicketReference repository=""
revision="c2f6c05c4cc73e831b7e852eb58bd6d7a83fa46c"
Refs #32943 -- Added support for covering exclusion constraints using SP-

GiST indexes on PostgreSQL 14+.
}}}

--
Ticket URL: <https://code.djangoproject.com/ticket/32943#comment:6>

Django

unread,

Oct 1, 2021, 7:46:14 AM10/1/21

to django-...@googlegroups.com

#32943: Add support for covering indexes and exclusion constraints for SP-GiST in
PostgreSQL 14+.
-------------------------------------+-------------------------------------
Reporter: Nick Pope | Owner: Nick Pope

Type: New feature | Status: closed
Component: contrib.postgres | Version: dev
Severity: Normal | Resolution: fixed