Skip to content
This repository has been archived by the owner on Apr 26, 2024. It is now read-only.

Refuse to run against postgres with a non-C collation #6722

Closed
richvdh opened this issue Jan 16, 2020 · 1 comment
Closed

Refuse to run against postgres with a non-C collation #6722

richvdh opened this issue Jan 16, 2020 · 1 comment
Labels
z-p2 (Deprecated Label)

Comments

@richvdh
Copy link
Member

richvdh commented Jan 16, 2020

A number of people have reported (#6696) database index corruption which basically stems from their databases having a UTF-8 collation setting.

Our documentation tells you to set the collation to "C" to avoid this sort of thing (and possibly improve performance, according to postgres-general), but this is little comfort to people who missed that advice and now have corrupt indexes to deal with.

By way of a preventative measure, maybe we should complain if somebody is using a different collation?

synapse=# SELECT datcollate FROM pg_database WHERE datname = current_database();
 datcollate 
------------
 C
(1 row)
This issue was closed.
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
z-p2 (Deprecated Label)
Projects
None yet
Development

No branches or pull requests

2 participants