Ah, that makes more sense.

I have implemented this and checked it into SVN.

You need to drop the index and then re-create it.

Be warned that it rebuilds all of the lucene full-text indices when you drop the index for a column. (yeah, I know, not ideal, but I don't know the code that well, and I'm out of time for hacking on this)

Come to think of it, you might be better off just using FTL_DROP_ALL and then re-creating the necessary indices.


On 2013-01-08 09:27, Daniel Ziltener wrote:
I think you misunderstood my intentions. What I'm trying to do is that I want to first create a table and the fulltext index for it - no problem. Then I want to alter the table by adding a column and want to add that column to the index, which does not seem to work?

Am Mittwoch, 2. Januar 2013 15:40:04 UTC+1 schrieb Noel Grandin:

    See documentation:
    http://h2database.com/html/tutorial.html#fulltext
    <http://h2database.com/html/tutorial.html#fulltext>


--
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to 
[email protected].
For more options, visit this group at 
http://groups.google.com/group/h2-database?hl=en.

Reply via email to