pgsql: Modify CREATE DATABASE to enforce that the source database's

From: tgl(at)postgresql(dot)org (Tom Lane)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Modify CREATE DATABASE to enforce that the source database's
Date: 2009-05-06 16:15:21
Message-ID: 20090506161522.190C4754069@cvs.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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)

Browse pgsql-committers by date

  From Date Subject
Next Message Tom Lane 2009-05-06 20:31:18 pgsql: Tweak distribute_qual_to_rels so that when we decide a
Previous Message Magnus Hagander 2009-05-06 13:39:33 Re: pgsql: Minor improvement: avoid assuming that GetLastError value cannot