#26684 closed Cleanup/optimization (fixed)
Example for Full-Text Search Index doesn't work
| Reported by: | Christophe Pettus | Owned by: | Christophe Pettus |
|---|---|---|---|
| Component: | Documentation | Version: | 1.10 |
| Severity: | Release blocker | Keywords: | |
| Cc: | Triage Stage: | Accepted | |
| Has patch: | yes | Needs documentation: | no |
| Needs tests: | no | Patch needs improvement: | no |
| Easy pickings: | no | UI/UX: | no |
Description (last modified by )
The example given for creating an index on a to_tsvector() call doesn't actually work, since to_tsvector() is not immutable (the results of it can change with changes to the underlying dictionaries it is ruled it is built on).
xof=# create table t (z text); CREATE TABLE xof=# create index on t(to_tsvector(z)); ERROR: functions in index expression must be marked IMMUTABLE
(As a note, indexes on tsvectors should be GIN indexes rather than B-tree.)
For documentation purposes, I'd suggest pointing the reader to the PostgreSQL documentation that describes how to handle this situation.
Change History (7)
comment:1 by , 8 years ago
| Description: | modified (diff) |
|---|
comment:2 by , 8 years ago
| Owner: | changed from to |
|---|---|
| Status: | new → assigned |
comment:4 by , 8 years ago
| Resolution: | → fixed |
|---|---|
| Status: | assigned → closed |
Documentation patch pull request submitted.
comment:5 by , 8 years ago
| Has patch: | set |
|---|---|
| Triage Stage: | Unreviewed → Accepted |
A ticket isn't marked fixed until the patch is committed.
Note:
See TracTickets
for help on using tickets.
PR