Re: \dS and \df crashing psql

> First of all, this was not a Postgres bug but a configuration mistake on
> my part.  I had been meaning to write back to the list explaining what
> really happened:
>
> 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.

Of course regexp should not crash in this situation above. Thanks for
the info. I will dig into the problem.
--
Tatsuo Ishii