Re: [GENERAL] How I changed the encoding of template1 after the fact

2006-02-23 Thread Tom Lane
Kevin Murphy <[EMAIL PROTECTED]> writes: > Here's a condensed example, in which template1 is recreated to change > its default encoding: If you're willing to fool around at that level, why not just "UPDATE pg_database SET datencoding = ..." The restriction against dropping template databases is

[GENERAL] How I changed the encoding of template1 after the fact

2006-02-23 Thread Kevin Murphy
I wanted to change the encoding of the template1 database, but when I tried to drop template1, I get the message, "ERROR: cannot drop a template database". The docs (http://www.postgresql.org/docs/8.1/interactive/manage-ag-templatedbs.html) say that this is possible, but a user comment on th