Re: 8.4b2 tsearch2 strange error

Поиск
Список
Период
Сортировка
От Kevin Grittner
Тема Re: 8.4b2 tsearch2 strange error
Дата
Msg-id 4A26BAA6020000250002748B@gw.wicourts.gov
обсуждение исходный текст
Ответ на Re: 8.4b2 tsearch2 strange error  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Andrew Dunstan
Дата:
Сообщение: Re: It's June 1; do you know where your release is?
Следующее
От: Dave Page
Дата:
Сообщение: Re: It's June 1; do you know where your release is?