tsearch2 index missing

From: Toby Tremayne <toby(at)lyricist(dot)com(dot)au>
To: pgsql-general(at)postgresql(dot)org
Subject: tsearch2 index missing
Date: 2007-02-18 07:23:07
Message-ID: 25DFED29-ECF5-44DD-B8F7-A9814E20D01D@lyricist.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Browse pgsql-general by date

  From Date Subject
Next Message RPK 2007-02-18 08:05:52 Encryption/Decryption in PGSQL
Previous Message Joshua D. Drake 2007-02-18 03:20:30 Re: Addons