Re: \dS and \df <pattern> crashing psql

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Nishad PRAKASH <prakashn(at)uci(dot)edu>
Cc: Peter Eisentraut <peter_e(at)gmx(dot)net>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: \dS and \df <pattern> crashing psql
Date: 2000-05-26 01:00:07
Message-ID: 1233.959302807@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-hackers

Nishad PRAKASH <prakashn(at)uci(dot)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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tatsuo Ishii 2000-05-26 01:34:32 Re: \dS and \df <pattern> crashing psql
Previous Message Nishad PRAKASH 2000-05-26 00:37:12 Re: \dS and \df <pattern> crashing psql

Browse pgsql-hackers by date

  From Date Subject
Next Message Chris Bitmead 2000-05-26 01:14:09 Re: gram.y PROBLEM with UNDER
Previous Message Bruce Momjian 2000-05-26 00:49:18 Re: Any reason to use pg_dumpall on an idle database