Opened 17 years ago

Last modified 11 months ago

#3254 new New feature

[patch] experimental fulltext search support for postgres, oracle and mssql — at Version 19

Reported by: Ronny Pfannschmidt Owned by: nobody
Component: Database layer (models, ORM) Version:
Severity: Normal Keywords: oracle fulltext search postgresql postgres mysql
Cc: sam@…, johann.queuniet@…, hv@…, rboumart@…, dan.fairs@…, twidi@…, Matt Boersma, justinlilly@…, James Pic, robinchew@…, niwi@…, slav0nic@…, mpessas@…, tomi.kyostila@…, Matt Goldman Triage Stage: Accepted
Has patch: no Needs documentation: no
Needs tests: no Patch needs improvement: no
Easy pickings: no UI/UX: no

Description (last modified by Ramiro Morales)

I didn't like it was missing.

oracle, mssql : add a FulltextIndex for the Fields

postgresql: for each FulltextField add a extra tsvector Field named like "%(fieldname)_tsv"

Problems with sqlite fts:

  • they stated a match statement may only be used once in a query
  • it needs a very specific syntax to search multiple fields
  • i have no idea how to get that into the ORM

Change History (22)

by Ronny Pfannschmidt <ronny.pfannschmidt@…>, 17 years ago

comment:1 by Simon G. <dev@…>, 17 years ago

Summary: [patch] experimental fts support for postgres, oracle and mssql[patch] experimental fulltext search support for postgres, oracle and mssql
Triage Stage: UnreviewedDesign decision needed

This is a very simple little patch - if accepted it'll need some docs. Shouldn't be too hard to implement MySQL fulltext searching too, but this will require a special index to be created.

comment:2 by anonymous, 17 years ago

Cc: sam@… added

comment:3 by djangoproject.com@…, 17 years ago

Typo in patch: plainto_tsquery in psycoph2/base.py should be to_tsquery
Corrected patch attached.

by djangoproject.com@…, 17 years ago

Corrected patch

comment:4 by James Bennett, 17 years ago

#4676 was a duplicate, and has an alternate implementation for PostgreSQL.

comment:5 by djangoproject.com@…, 16 years ago

Patches attached to this ticket do not work correctly with PostgreSQL, please use patch http://code.djangoproject.com/attachment/ticket/4676/sql.diff in ticket #4676 (which also describes the correct database set-up by the way).

comment:6 by Jacob, 16 years ago

Component: MetasystemDatabase wrapper
Needs documentation: set
Needs tests: set
Patch needs improvement: set
Triage Stage: Design decision neededAccepted

comment:7 by anonymous, 16 years ago

Cc: johann.queuniet@… added

comment:8 by Jacob, 16 years ago

Reporter: changed from Ronny Pfannschmidt <ronny.pfannschmidt@…> to Ronny Pfannschmidt

comment:9 by anonymous, 16 years ago

Postgres 8.3 now has full-text searching. Not sure if this changes anything here or not...

in reply to:  9 comment:10 by anonymous, 16 years ago

Replying to anonymous:

Postgres 8.3 now has full-text searching. Not sure if this changes anything here or not...

http://www.postgresql.org/docs/8.3/static/textsearch.html

comment:11 by Thomas Güttler, 16 years ago

Cc: hv@… added

comment:12 by Thomas Güttler, 16 years ago

Both patches (last from june 2006) are broken since [5957]

comment:13 by Thomas Güttler, 16 years ago

Sorry, I meant june 2007 (The date format of trac is hard to read for germans ...)

by rachid, 16 years ago

Attachment: fts-pstgres.patch added

corrected Patch (only for postgres)

comment:14 by rachid, 16 years ago

Cc: rboumart@… added

I added a Patch against 7231. It is only for postgres. But i think it would be straight forward for the other backend.

comment:15 by Dan Fairs, 16 years ago

Cc: dan.fairs@… added

comment:16 by anonymous, 15 years ago

Cc: twidi@… added

comment:17 by Matt Boersma, 15 years ago

Cc: Matt Boersma added

comment:18 by Matt Boersma, 15 years ago

Keywords: oracle fulltext search added

comment:19 by Ramiro Morales, 15 years ago

Description: modified (diff)

(description)

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