{"comment":{"url":"https://api.github.com/repos/urbanriskmap/cognicity-schema/comments/19586646","html_url":"https://github.com/urbanriskmap/cognicity-schema/commit/d66e4ae5c93a4b5d622bee2e8fa823c336dcb696#commitcomment-19586646","id":19586646,"user":{"login":"matthewberryman","id":2288238,"avatar_url":"https://avatars.githubusercontent.com/u/2288238?v=3","gravatar_id":"","url":"https://api.github.com/users/matthewberryman","html_url":"https://github.com/matthewberryman","followers_url":"https://api.github.com/users/matthewberryman/followers","following_url":"https://api.github.com/users/matthewberryman/following{/other_user}","gists_url":"https://api.github.com/users/matthewberryman/gists{/gist_id}","starred_url":"https://api.github.com/users/matthewberryman/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/matthewberryman/subscriptions","organizations_url":"https://api.github.com/users/matthewberryman/orgs","repos_url":"https://api.github.com/users/matthewberryman/repos","events_url":"https://api.github.com/users/matthewberryman/events{/privacy}","received_events_url":"https://api.github.com/users/matthewberryman/received_events","type":"User","site_admin":false},"position":null,"line":null,"path":null,"commit_id":"d66e4ae5c93a4b5d622bee2e8fa823c336dcb696","created_at":"2016-10-26T22:28:26Z","updated_at":"2016-10-26T22:28:26Z","body":"I tried this on a blank RDS setup both with and without the en_US collation line and the resulting template has en_US collection in both cases. I did try on my Mac, which has en_AU as the template and I got the following error:\r\npsql:createdb.sql:7: ERROR:  new collation (en_US.UTF-8) is incompatible with the collation of the template database (en_AU.UTF-8)\r\nHINT:  Use the same collation as in the template database, or use template0 as template.\r\n(Being pedantic and technical I am pretty sure collation rules are the same anyway across these two dialects). \r\ni.e. whether you see the behaviour you describe, or the behaviour as described in the docs, depends on the template database used. I would say for consistency reasons best to explicitly specify the LC_COLLATION and then (since the template0 database is not the default template) leave your comment in the README.md :)"}}
{"actor":{"display_login":"matthewberryman"}}