[Django] #37219: Add GeneratedField example to PostgreSQL search reference.

[Django]

#37219: Add GeneratedField example to PostgreSQL search reference.
-------------------------------------+-------------------------------------
Reporter: Carlton | Owner: Carlton Gibson
Gibson |
Type: | Status: assigned
Cleanup/optimization |
Component: | Version: 6.0
Documentation |
Severity: Normal | Keywords:
Triage Stage: | Has patch: 1
Unreviewed |
Needs documentation: 0 | Needs tests: 0
Patch needs improvement: 0 | Easy pickings: 0
UI/UX: 0 |
-------------------------------------+-------------------------------------
I was reading the
[https://docs.djangoproject.com/en/dev/ref/contrib/postgres/search/#performance
Performance section] of the Postgres Full text search reference.

The requirement to use a trigger with SearchVectorField made me think of
using a GeneratedField. I think that would be a good example to add.
--
Ticket URL: <https://code.djangoproject.com/ticket/37219>
Django <https://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.

[Django]

#37219: Add GeneratedField example to PostgreSQL search reference.
-------------------------------------+-------------------------------------

Reporter: Carlton Gibson | Owner: Carlton
Type: | Gibson
Cleanup/optimization | Status: assigned
Component: Documentation | Version: 6.0
Severity: Normal | Resolution:
Keywords: | Triage Stage:
| Unreviewed
Has patch: 1 | Needs documentation: 0

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

Comment (by Carlton Gibson):

[https://github.com/django/django/pull/21634 PR]
--
Ticket URL: <https://code.djangoproject.com/ticket/37219#comment:1>

[Django]

#37219: Add GeneratedField example to PostgreSQL search reference.
-------------------------------------+-------------------------------------
Reporter: Carlton Gibson | Owner: Carlton
Type: | Gibson
Cleanup/optimization | Status: assigned
Component: Documentation | Version: 6.0
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 Simon Charette):

* stage: Unreviewed => Accepted

Comment:

I think we should even considering replacing/dropping the trigger section
entirely given there is almost no reason I can think of where it's
preferable over a generated field particularly if Postgres eventually add
support for indexing virtual ones.
--
Ticket URL: <https://code.djangoproject.com/ticket/37219#comment:2>

[Django]

#37219: Add GeneratedField example to PostgreSQL search reference.
-------------------------------------+-------------------------------------
Reporter: Carlton Gibson | Owner: Carlton
Type: | Gibson
Cleanup/optimization | Status: assigned
Component: Documentation | Version: 6.0
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
-------------------------------------+-------------------------------------

Comment (by Carlton Gibson):

I wondered if there might be an example (maybe cross model) that wasn’t
compatible with generated field’s constraints. (But I don’t have one to
hand.)
--
Ticket URL: <https://code.djangoproject.com/ticket/37219#comment:3>

[Django]

#37219: Add GeneratedField example to PostgreSQL search reference.
-------------------------------------+-------------------------------------
Reporter: Carlton Gibson | Owner: Carlton
Type: | Gibson
Cleanup/optimization | Status: assigned
Component: Documentation | Version: 6.0
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 Jacob Walls):

* stage: Accepted => Ready for checkin

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

[Django]

#37219: Add GeneratedField example to PostgreSQL search reference.
-------------------------------------+-------------------------------------
Reporter: Carlton Gibson | Owner: Carlton
Type: | Gibson

Cleanup/optimization | Status: closed
Component: Documentation | Version: 6.0
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 Jacob Walls <jacobtylerwalls@…>):

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

Comment:

In [changeset:"dd4fc22d4cfd182c04e0468ae4a8f630fbb2fd1b" dd4fc22]:
{{{#!CommitTicketReference repository=""
revision="dd4fc22d4cfd182c04e0468ae4a8f630fbb2fd1b"
Fixed #37219 -- Added GeneratedField example to PostgreSQL search
reference.
}}}
--
Ticket URL: <https://code.djangoproject.com/ticket/37219#comment:5>

[Django]

#37219: Add GeneratedField example to PostgreSQL search reference.
-------------------------------------+-------------------------------------
Reporter: Carlton Gibson | Owner: Carlton
Type: | Gibson
Cleanup/optimization | Status: closed
Component: Documentation | Version: 6.0
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
-------------------------------------+-------------------------------------

Comment (by Jacob Walls <jacobtylerwalls@…>):

In [changeset:"11c290f4f925e9bf3d616d664778e2da6db5f8f5" 11c290f4]:
{{{#!CommitTicketReference repository=""
revision="11c290f4f925e9bf3d616d664778e2da6db5f8f5"
[6.1.x] Fixed #37219 -- Added GeneratedField example to PostgreSQL search
reference.

Backport of dd4fc22d4cfd182c04e0468ae4a8f630fbb2fd1b from main.
}}}
--
Ticket URL: <https://code.djangoproject.com/ticket/37219#comment:6>

[Django]

#37219: Add GeneratedField example to PostgreSQL search reference.
-------------------------------------+-------------------------------------
Reporter: Carlton Gibson | Owner: Carlton
Type: | Gibson
Cleanup/optimization | Status: closed
Component: Documentation | Version: 6.0
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
-------------------------------------+-------------------------------------
Comment (by Jacob Walls <jacobtylerwalls@…>):

In [changeset:"143db1d7cea45353d15924729d3671d473d58f66" 143db1d7]:
{{{#!CommitTicketReference repository=""
revision="143db1d7cea45353d15924729d3671d473d58f66"
[6.0.x] Fixed #37219 -- Added GeneratedField example to PostgreSQL search

reference.

Backport of dd4fc22d4cfd182c04e0468ae4a8f630fbb2fd1b from main.
}}}
--

Ticket URL: <https://code.djangoproject.com/ticket/37219#comment:7>