Jaime Casanova wrote:
I was trying to create a database and found that we are using LC_COLLATE and LC_CTYPE, why not simply COLLATE and CTYPE?
This was discussed recently, and in fact changed from COLLATE/CTYPE to LC_COLLATE/LC_CTYPE. The reason is that LC_COLLATE and LC_CTYPE makes it more clear that the options set the LC_COLLATE and LC_CTYPE environment variables. There is also precedent: the pre-existing initdb options were called --lc-collate and --lc-ctype, so the new createdb options are quite naturally also called --lc-collate and --lc-ctype, and since they're called that, it would be weird if the CREATE DATABASE options had different names.
-- Heikki Linnakangas EnterpriseDB http://www.enterprisedb.com -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers