OSDN Git Service

Adjust pg_dumpall so that it emits ENCODING, LC_COLLATE, and LC_CTYPE options
authorTom Lane <tgl@sss.pgh.pa.us>
Sun, 10 May 2009 02:51:44 +0000 (02:51 +0000)
committerTom Lane <tgl@sss.pgh.pa.us>
Sun, 10 May 2009 02:51:44 +0000 (02:51 +0000)
commit4db44b433b857dc2a823eb4673d94346224df698
tree4bd40ea9185a7eb78f61788f69f3f0b533ca3a05
parent8dcf18414ba3fd68970fb5095f26bb9f358dedfe
Adjust pg_dumpall so that it emits ENCODING, LC_COLLATE, and LC_CTYPE options
in its CREATE DATABASE commands only for databases that have settings
different from the installation defaults.  This is a low-tech method of
avoiding unnecessary platform dependencies in dump files.  Eventually we ought
to have a platform-independent way of specifying LC_COLLATE and LC_CTYPE, but
that's not going to happen for 8.4, and this patch at least avoids the issue
for people who aren't setting up per-database locales.  ENCODING doesn't have
the platform dependency problem, but it seems consistent to make it act the
same as the locale settings.
src/bin/pg_dump/pg_dumpall.c