[google-cloud-sql-discuss] Language support on SQL PostgreSQL

Good morning,

I'm trying to use Postgres' full-text search capabilities and I have the following issue:

database=> SELECT uuid, ts_rank_cd(to_tsvector(name), to_tsquery('word')) AS score FROM travel;
ERROR: SQLSTATE[42704]: Undefined object: 7 ERROR: text search configuration "pg_catalog.english" does not exist

The error is clear enough, I have to say, there isn't much in the "pg_ts_config" table:

database=> select * from pg_ts_config;
 cfgname | cfgnamespace | cfgowner | cfgparser
---------+--------------+----------+-----------
 simple  |           11 |       10 |      3722
(1 row)

Based on this thread on the PostgreSQL's mailing-list, it looks like something has to be installed first. Is there any way to get this working with Google Cloud SQL PostgreSQL?

Thank you very much,

Samuel.

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/f3978f72-7e09-41ca-9114-6e407cd28de6%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.