Kevin Murphy <murphy(at)genome(dot)chop(dot)edu> 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 specifically
intended to make it difficult for those who don't know what they are
doing to shoot themselves in the foot. So I'm disinclined to make the
manual include easy-to-follow directions for bypassing the safety
interlock --- if you can't be bothered to find out how, you shouldn't
be doing it.
regards, tom lane