Timeline for Collations and codesets in PostgreSQL 9.x
Current License: CC BY-SA 3.0
5 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Oct 19, 2016 at 6:18 | comment | added | Muton | I guess one possible reason for the reason for pg_collation only listing those three values is because "PostgreSQL generally ignores all collations that do not have collencoding equal to either the current database's encoding or -1...". | |
| Oct 19, 2016 at 6:09 | comment | added | Muton | Thanks! Capitalization works as you described. Setting the collation when creating the database, however, does not work. I get the same error I get from initdb: ERROR: invalid locale name: "English_United States.UTF8". The pg_collation catalog only has "default", "C" and "POSIX". | |
| Oct 18, 2016 at 19:35 | history | edited | Solomon Rutzky | CC BY-SA 3.0 |
minor edits
|
| Oct 18, 2016 at 19:26 | history | edited | Solomon Rutzky | CC BY-SA 3.0 |
minor clarification
|
| Oct 18, 2016 at 18:15 | history | answered | Solomon Rutzky | CC BY-SA 3.0 |