Allow Creating FTS on a view

[aersam]

FTS on a view would be really nice. As a hack, I currently persist my view, create the FTS, drop the table and create the view again :) As FTS is not updated anyway, I think allowing it on a view makes total sense

[devlux76]

Thank you for this advice! I was trying to figure out how to do something like that just now.

[ukclivecox]

Any reason a view is restricted? As I have many tables combined in a view - so creating 1 FTS off the text columns in the view would be very useful.

[lnkuiper]

There is no reason a view wouldn't work! I think it would be really handy. It's just that I have no time to work on the fts extension. Contributions are appreciated