Re: [rt-users] RT full text indexing with PostgreSQL

2009-02-06 Thread Kenneth Marshall
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

Re: [rt-users] RT full text indexing with PostgreSQL

2009-02-06 Thread Kenneth Marshall
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

Re: [rt-users] RT full text indexing with PostgreSQL

2009-02-03 Thread Kenneth Marshall
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. Here are the commands for adding the triggers to

Re: [rt-users] RT full text indexing with PostgreSQL

2009-02-02 Thread Kenneth Marshall
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. Here are the commands for adding the triggers to keep

[rt-users] RT full text indexing with PostgreSQL

2009-02-01 Thread Kenneth Marshall
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. Here are the commands for adding the triggers to keep the textsearchable columns corresponding to attachments.subject/content