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