Re: \dS and \df <pattern> crashing psql
Tom Lane <tgl@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Nishad PRAKASH <prakashn@uci.edu>
Cc: Peter Eisentraut <peter_e@gmx.net>, pgsql-bugs@postgresql.org
Date: 2000-05-26T01:00:07Z
Lists: pgsql-bugs, pgsql-hackers
Nishad PRAKASH <prakashn@uci.edu> writes: > I compiled 7.0 with locale support, recode, and multibyte options all > enabled. In the postgres (db superuser) .cshrc, I had set LC_CTYPE to > "en_US". This was the problem. When I would start postmaster and run > anything that involved a regexp (and the query that \dS expands to uses > regexps) on a "bytea" type field, psql would crash. > To fix this, I tried first letting the locale default to "C", then setting > LC_CTYPE to "iso_8859_1". Starting postmaster with either of these works > perfectly. > If you are still interested in server output or backtraces (perhaps to > implement a more graceful exit?), I'd be glad to send them, but I'm sure > you can replicate this pretty easily now if required. Hmm, news to us. It may be a platform-specific problem, so yes please do send a backtrace. regards, tom lane