| 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: | Whole Thread | Raw Message | 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
| 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 |