alter percolate table

General Discussions - English
1

Hi,
Is it possible to alter percolate table ?
Table was created like:
create table perc(id bigint, description text, color string) type='pq'
Later we have to filter docs out also by additional attribute, let’ say by size.
I’ve tried:
alter table perc add column size float
but id doesn’t work.
No mentions for altering percolate table in documentation.
So is is possible to add another filter attribute to percolate table ?

Thanks in advance

2

pq index does not support any alter.
You need to recreate your index and repopulate it.

It also worth to create feature request at Github to get informed on progress.