Re: 8.4b2 tsearch2 strange error - Mailing list pgsql-hackers
From | Kevin Grittner |
---|---|
Subject | Re: 8.4b2 tsearch2 strange error |
Date | |
Msg-id | 4A26BAA6020000250002748B@gw.wicourts.gov Whole thread Raw |
In response to | Re: 8.4b2 tsearch2 strange error (Tom Lane <tgl@sss.pgh.pa.us>) |
List | pgsql-hackers |
Tom Lane <tgl@sss.pgh.pa.us> wrote: > Tatsuo Ishii <ishii@postgresql.org> writes: >>> initdb -E UTF-8 --no-locale /path/to/database > >> So locale is "C". I believe we are not customizing >> default_text_search_config. I'm not think of any nondefault >> configuration settings. > > Huh. So that should be the same case I tested here. I wonder why > I can't duplicate it. Can anyone else get the failure? I can't duplicate it on beta2, either. I didn't use the -E switch on initdb. initdb --no-locale /path/to/database kgrittn@ATHENA:~> uname -a Linux ATHENA 2.6.16.60-0.31-smp #1 SMP Tue Oct 7 16:16:29 UTC 2008 x86_64 x86_64 x86_64 GNU/Linux kgrittn@ATHENA:~> cat /etc/SuSE-release SUSE Linux Enterprise Server 10 (x86_64) VERSION = 10 PATCHLEVEL = 2 kgrittn@ATHENA:~> /usr/local/pgsql-8.4beta2/bin/pg_config BINDIR = /usr/local/pgsql-8.4beta2/bin DOCDIR = /usr/local/pgsql-8.4beta2/share/doc HTMLDIR = /usr/local/pgsql-8.4beta2/share/doc INCLUDEDIR = /usr/local/pgsql-8.4beta2/include PKGINCLUDEDIR = /usr/local/pgsql-8.4beta2/include INCLUDEDIR-SERVER = /usr/local/pgsql-8.4beta2/include/server LIBDIR = /usr/local/pgsql-8.4beta2/lib PKGLIBDIR = /usr/local/pgsql-8.4beta2/lib LOCALEDIR = /usr/local/pgsql-8.4beta2/share/locale MANDIR = /usr/local/pgsql-8.4beta2/share/man SHAREDIR = /usr/local/pgsql-8.4beta2/share SYSCONFDIR = /usr/local/pgsql-8.4beta2/etc PGXS = /usr/local/pgsql-8.4beta2/lib/pgxs/src/makefiles/pgxs.mk CONFIGURE = '--prefix=/usr/local/pgsql-8.4beta2' '--enable-integer-datetimes' '--enable-debug' '--disable-nls' '-with-libxml' CC = gcc CPPFLAGS = -D_GNU_SOURCE -I/usr/include/libxml2 CFLAGS = -O2 -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -fno-strict-aliasing -fwrapv -g CFLAGS_SL = -fpic LDFLAGS = -Wl,--as-needed -Wl,-rpath,'/usr/local/pgsql-8.4beta2/lib' LDFLAGS_SL = LIBS = -lpgport -lxml2 -lz -lreadline -lcrypt -ldl -lm VERSION = PostgreSQL 8.4beta2 kgrittn@ATHENA:~> /usr/local/pgsql-8.4beta2/bin/pg_controldata /var/pgsql/data/kgrittn2 pg_control version number: 843 Catalog version number: 200904091 Database system identifier: 5340644220088610719 Database cluster state: in production pg_control last modified: Wed 03 Jun 2009 05:42:18 PM CDT Latest checkpoint location: 12/5F9CD778 Prior checkpoint location: 12/5F9CD700 Latest checkpoint's REDO location: 12/5F9CD778 Latest checkpoint's TimeLineID: 1 Latest checkpoint's NextXID: 0/4517 Latest checkpoint's NextOID: 57344 Latest checkpoint's NextMultiXactId: 1 Latest checkpoint's NextMultiOffset: 0 Time of latest checkpoint: Wed 03 Jun 2009 05:42:18 PM CDT Minimum recovery ending location: 0/0 Maximum data alignment: 8 Database block size: 8192 Blocks per segment of large relation: 131072 WAL block size: 8192 Bytes per WAL segment: 16777216 Maximum length of identifiers: 64 Maximum columns in an index: 32 Maximum size of a TOAST chunk: 1996 Date/time type storage: 64-bit integers Float4 argument passing: by value Float8 argument passing: by value kgrittn@ATHENA:~> cat /var/pgsql/data/kgrittn2/postgresql.conf port = 5442 max_connections = 10 shared_buffers = 250MB max_prepared_transactions = 0 work_mem = 50MB maintenance_work_mem = 1GB checkpoint_segments = 20 checkpoint_timeout = 30min effective_cache_size = 100GB geqo = off from_collapse_limit = 20 join_collapse_limit = 20 datestyle = 'iso, mdy' lc_messages = 'C' lc_monetary = 'C' lc_numeric = 'C' lc_time = 'C' default_text_search_config = 'pg_catalog.english' escape_string_warning = off sql_inheritance = off standard_conforming_strings = on -Kevin
pgsql-hackers by date: