]> granicus.if.org Git - postgresql/commit
Store current LC_COLLATE and LC_CTYPE settings in pg_control during initdb;
authorTom Lane <tgl@sss.pgh.pa.us>
Sat, 25 Nov 2000 20:33:54 +0000 (20:33 +0000)
committerTom Lane <tgl@sss.pgh.pa.us>
Sat, 25 Nov 2000 20:33:54 +0000 (20:33 +0000)
commitbbea3643a3a6425f92d0db9ff16c7f73a31a466c
treef13bea7c027c5e4e5155eb802a16e0e2c1d3a0c8
parent0432ce994d3971ced6e336e9f58444d5322c3270
Store current LC_COLLATE and LC_CTYPE settings in pg_control during initdb;
re-adopt these settings at every postmaster or standalone-backend startup.
This should fix problems with indexes becoming corrupt due to failure to
provide consistent locale environment for postmaster at all times.  Also,
refuse to start up a non-locale-enabled compilation in a database originally
initdb'd with a non-C locale.  Suppress LIKE index optimization if locale
is not "C" or "POSIX" (are there any other locales where it's safe?).
Issue NOTICE during initdb if selected locale disables LIKE optimization.
doc/src/sgml/runtime.sgml
src/backend/access/transam/xlog.c
src/backend/bootstrap/bootstrap.c
src/backend/optimizer/path/indxpath.c
src/backend/postmaster/postmaster.c
src/backend/tcop/postgres.c
src/backend/utils/adt/cash.c
src/backend/utils/adt/selfuncs.c
src/include/access/xlog.h
src/include/catalog/catversion.h
src/include/utils/builtins.h