Scott Marlowe <scott.marlowe@xxxxxxxxx> writes: > On Fri, Sep 30, 2011 at 12:26 PM, Cody Caughlan <toolbag@xxxxxxxxx> wrote: >> So it appears both template0 & template1 are SQL_ASCII, so how would >> creating from a new DB from template0 be any different than template1? > P.s. I'm not sure why it works, I just know that it does. :) CREATE DATABASE assumes that template0 cannot contain any non-ASCII data, so it's okay to clone it and then pretend that the result has some other encoding. The same assumption cannot be made for template1, since that's user-modifiable. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
