Thread: tsearch2 index missing

tsearch2 index missing

From
Toby Tremayne
Date:
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