pgsql: Modify CREATE DATABASE to enforce that the source database's - Mailing list pgsql-committers

From tgl@postgresql.org (Tom Lane)
Subject pgsql: Modify CREATE DATABASE to enforce that the source database's
Date
Msg-id 20090506161522.190C4754069@cvs.postgresql.org
Whole thread Raw
List pgsql-committers
Log Message:
-----------
Modify CREATE DATABASE to enforce that the source database's encoding setting
must be used for the new database, except when copying from template0.
This is the same rule that we now enforce for locale settings, and it has
the same motivation: databases other than template0 might contain data that
would be invalid according to a different setting.  This represents another
step in a continuing process of locking down ways in which encoding violations
could occur inside the backend.  Per discussion of a few days ago.

In passing, fix pre-existing breakage of mbregress.sh, and fix up a couple
of ereport() calls in dbcommands.c that failed to specify sqlstate codes.

Modified Files:
--------------
    pgsql/doc/src/sgml:
        charset.sgml (r2.93 -> r2.94)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/charset.sgml?r1=2.93&r2=2.94)
        manage-ag.sgml (r2.57 -> r2.58)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/manage-ag.sgml?r1=2.57&r2=2.58)
    pgsql/doc/src/sgml/ref:
        create_database.sgml (r1.51 -> r1.52)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/ref/create_database.sgml?r1=1.51&r2=1.52)
    pgsql/src/backend/commands:
        dbcommands.c (r1.223 -> r1.224)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/commands/dbcommands.c?r1=1.223&r2=1.224)
    pgsql/src/test/mb:
        README (r1.3 -> r1.4)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/test/mb/README?r1=1.3&r2=1.4)
        mbregress.sh (r1.9 -> r1.10)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/test/mb/mbregress.sh?r1=1.9&r2=1.10)

pgsql-committers by date:

Previous
From: Magnus Hagander
Date:
Subject: Re: pgsql: Minor improvement: avoid assuming that GetLastError value cannot
Next
From: tgl@postgresql.org (Tom Lane)
Date:
Subject: pgsql: Tweak distribute_qual_to_rels so that when we decide a