On Fri, Feb 06, 2009 at 07:44:25AM -0600, Kenneth Marshall wrote: > On Fri, Feb 06, 2009 at 11:01:31AM +0100, Rafael Martinez wrote: > > Kenneth Marshall wrote: > > > On Sun, Feb 01, 2009 at 09:41:42PM -0600, Kenneth Marshall wrote: > > >>> I just updated the PostgreSQLFullText pages on the wiki with > > >>> the triggers to keep the parsed document columns updated whenever > > >>> there is a change to the dependent columns. > > >>> > > > > Hello Kenneth > > > > First of all thank you for this work. We have been waiting for this for > > a long time but the work we thought had to be done with the RT-code has > > stopped us to implement full text search. > > > > After a close check of the wiki page: > > http://wiki.bestpractical.com/view/PostgreSQLFullText .... > > > > I think that the patch of DBIx::SearchBuilder is not 100% > > complete/correct. All lines has the '-' (minus) symbol. I suppose that > > at least some of them should be '+' and not '-'? > > > > This is a tiny patch, would not be an idea to implement this in RT-core > > functionality, maybe with some config parameters that > > activate/deactivate full text search (when using postgresql/oracle, etc) . > > > > regards > > -- > > Rafael Martinez, <r.m.guerr...@usit.uio.no> > > Center for Information Technology Services > > University of Oslo, Norway > > > > PGP Public Key: http://folk.uio.no/rafael/ > > > > Rafael, > > The diff I posted was to go from the FULLTEXT patch to the > original one. I agree that it would make more sense to go the > other way. I have updated the page. I do think that having it > as an option in RT-core would be nice. I know for PostgreSQL > versions 8.3 and higher, you can use the patch by default since > FULLTEXT indexing comes with the database as a standard feature. > PostgreSQL will simply convert the attachment field automatically > using to_tsvector() on the fly so it will just work as is. Of > course creating the needed index will greatly improve the performance. > I do not know if OracleText has the same fallback in the absence of > the FULLTEXT setup and index. I suspect that run-time tests for > a configuration option would be needed. > > Cheers, > Ken
Sorry about this post. It applied to the version that did not use an additional column to store the processed attachments/largecontent not the one I posted. Ken _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
