I'm using tsearch 2 - added a column named vectors to a table, updated it according to the documentation, created an index. So far it's all worked fine.
Problem is I decided to include a new column in the contents of vectors, so I added the column, deleted my index, re-updated the vectors column and added a trigger to update the vectors.
Now when I try to update I get an error message saying "tsvector column "contact_ft_index" does not exist"
What I don't understand is that the contact_ft_index it's talking about was never a column, it was the name of the previous index. Am I missing something here? How do I recover this?
Toby
-----------------------------------
Life is poetry, write it in your own words
-----------------------------------
Toby Tremayne
Senior Technical Consultant
Lyricist Software
0416 048 090
ICQ: 13107913