[YSQL] Add support for CREATE TEXT SEARCH TEMPLATE

[irizzant]

Jira Link: DB-1707
Hello
I have this issue while restoring my Postgres dump:

pg_restore: creating EXTENSION "unaccent"
pg_restore: [archiver (db)] Error from TOC entry 5; 3079 436183861 EXTENSION unaccent 
pg_restore: [archiver (db)] could not execute query: ERROR:  CREATE TEXT SEARCH TEMPLATE not supported yet
HINT:  Please report the issue on https://github.com/YugaByte/yugabyte-db/issues
    Command was: CREATE EXTENSION IF NOT EXISTS unaccent WITH SCHEMA public;

[ddorian]

@irizzant text searching isn't yet supported.
I believe your issue depends on:

1. gin/gist indexes YSQL - full text search  #3446
2. full text search YSQL - full text search  #3446

[irizzant]

@ddorian it looks like the mentioned issues do not mention the CREATE TEXT SEARCH TEMPLATE statement directly, this is why I opened this issue.
If you confirm that those issues fix also this we can close this and mark it as duplicate

[ddorian]

I believe we keep this. You should also subscribe at those 2 I think.

[irizzant]

Done, thank you for your suggestions. Is there any estimated date?

[rkarthik007]

Hi @irizzant ,

We're working on the 2.2 roadmap, and figuring out the timeline for this, please stay tuned! cc @ndeodhar

[GRoguelon]

Hi @irizzant ,

We're working on the 2.2 roadmap, and figuring out the timeline for this, please stay tuned! cc @ndeodhar

Hi @rkarthik007, any update on the 2.2 roadmap?

[ndeodhar]

Hi @GRoguelon , unfortunately, we won't be able to support this in 2.2 and will likely take this up post that (i.e. post June).

[GRoguelon]

@ndeodhar Thank you very much for the quick answer.

[rkarthik007]

Hi @GRoguelon,

There roadmap is now uploaded to GitHub, here is the v2.2 roadmap.

Please look at the Release Target column at items which have v2.2 as the value. Hope that helps. Would love to get any feedback you may have. Also, as @ndeodhar said, we were not able to accommodate the text search feature given all the other things going on. Happy to talk to you about alternative ways to achieve what you want - just holler on the community slack.