Re: How I changed the encoding of template1 after the fact - Mailing list pgsql-general

From Tom Lane
Subject Re: How I changed the encoding of template1 after the fact
Date
Msg-id 26266.1140731556@sss.pgh.pa.us
Whole thread Raw
In response to How I changed the encoding of template1 after the fact  (Kevin Murphy <murphy@genome.chop.edu>)
List pgsql-general
Kevin Murphy <murphy@genome.chop.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

pgsql-general by date:

Previous
From: Bernhard Weisshuhn
Date:
Subject: Re: Temporal Databases
Next
From: "Jim C. Nasby"
Date:
Subject: Re: now() time off