pgcentralfoundation
Locale of test databases should be controllable
The locale of databases created by pgx is whatever the system's locale is (since that's what Postgres does by default). In the context of pgx-tests, this can lead to accidentally creating tests that only work in the locale of the test author. For instance, 1-2-2020 gets parsed as Jan. 2 in the US but Feb. 1 in Canada.
Some parts of the database locale can't be changed after database creation, so one can't work around this by setting the database locale in tests. The only way around this is to change the system locale whenever pgx creates databases, which isn't ideal.
Ideally pgx should always set the locale of test databases to a configurable value (by default probably C, en_US.UTF-8 also works if you want to avoid a breaking change for American English speakers).
Yeaaaah, we really ought to be setting the locale to something that guarantees UTF-8 in/out. We don't want to have someone in China try installing PGX stuff, get their default locale, and then have PGX barf on EUC-CN text.
