How to create text index on a flex table which has composite primary key

dbadmin=> CREATE TEXT INDEX plain_text_search_index ON f_network_events(id, raw) TOKENIZER public.FlexTokenizer(long varbinary);
ROLLBACK 4550: Referenced primary key constraint does not exist

id is simply the identity column. The primary key is the composite of multiple columns but I don't know how to refer them in text index.


Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file