Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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)

pgsql-committers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group