Postgresql and pg_catalog.english support

237 views
Skip to first unread message

Alessandro Tagliapietra

unread,
Jun 16, 2017, 10:12:58 AM6/16/17
to Google Cloud SQL discuss
Hi there,

I've created a postgresl server on cloud sql, however it doens't come with the pg_catalog.english dictionary.

Why? Is there a way to add it?

Regards

Faizan (Cloud Platform Support)

unread,
Jun 16, 2017, 12:12:29 PM6/16/17
to Google Cloud SQL discuss
Hello Alessandro,

Support for multiple text search configuration including english will be available soon. You can refer to this feature request for updates.

Faizan

Ankush Agarwal

unread,
Jun 16, 2017, 1:30:39 PM6/16/17
to google-cloud...@googlegroups.com
Alessandro,

We currently support the following text search dictionaries. Are you not seeing this on your instance?

postgres=> \dFd
                             List of text search dictionaries
   Schema   |      Name       |                        Description
------------+-----------------+-----------------------------------------------------------
 pg_catalog | danish_stem     | snowball stemmer for danish language
 pg_catalog | dutch_stem      | snowball stemmer for dutch language
 pg_catalog | english_stem    | snowball stemmer for english language
 pg_catalog | finnish_stem    | snowball stemmer for finnish language
 pg_catalog | french_stem     | snowball stemmer for french language
 pg_catalog | german_stem     | snowball stemmer for german language
 pg_catalog | hungarian_stem  | snowball stemmer for hungarian language
 pg_catalog | italian_stem    | snowball stemmer for italian language
 pg_catalog | norwegian_stem  | snowball stemmer for norwegian language
 pg_catalog | portuguese_stem | snowball stemmer for portuguese language
 pg_catalog | romanian_stem   | snowball stemmer for romanian language
 pg_catalog | russian_stem    | snowball stemmer for russian language
 pg_catalog | simple          | simple dictionary: just lower case and check for stopword
 pg_catalog | spanish_stem    | snowball stemmer for spanish language
 pg_catalog | swedish_stem    | snowball stemmer for swedish language
 pg_catalog | turkish_stem    | snowball stemmer for turkish language




--
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+unsubscr...@googlegroups.com.
 To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/34adc3e9-f7ed-4fb2-9031-e0b2ba747d4b%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.



--
Ankush Agarwal

Software Engineer, Cloud SQL
 
There are 10 types of people in this world - those who understand binary and those who don't

Alessandro Tagliapietra

unread,
Jun 20, 2017, 1:04:54 AM6/20/17
to Google Cloud SQL discuss
Hi Ankush,

sorry for the delay but I didn't receive the notification. Anyway nope, I just have the simple dictionary (checked using that same command)

Seems I've to wait for the next cloud sql release for that https://issuetracker.google.com/issues/62068674#comment3
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsub...@googlegroups.com.

Ankush Agarwal

unread,
Jun 20, 2017, 11:29:15 AM6/20/17
to google-cloud...@googlegroups.com
Can you please send me your instance name and project name in a private message?

To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-d...@googlegroups.com.



--
Ankush Agarwal

Software Engineer, Cloud SQL
 
There are 10 types of people in this world - those who understand binary and those who don't

--
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-d...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/06540092-5712-4393-b6be-620f32fb30bc%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

Alessandro Tagliapietra

unread,
Jun 20, 2017, 11:30:33 AM6/20/17
to Google Cloud SQL discuss
In the meantime I've deleted the instance and created a postgresql instance on GKE because without that it was completely unusable by us, I'll create a new one and see if the problem persists
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsub...@googlegroups.com.



--
Ankush Agarwal

Software Engineer, Cloud SQL
 
There are 10 types of people in this world - those who understand binary and those who don't

--
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+unsub...@googlegroups.com.

Alessandro Tagliapietra

unread,
Jun 20, 2017, 11:49:02 AM6/20/17
to Google Cloud SQL discuss
Ok a newly created instance now has the english dictionary, probably mine was old.

Thank you for helping!
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsub...@googlegroups.com.



--
Ankush Agarwal

Software Engineer, Cloud SQL
 
There are 10 types of people in this world - those who understand binary and those who don't

--
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+unsub...@googlegroups.com.
Reply all
Reply to author
Forward
0 new messages