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
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 |