Skip site navigation (1) Skip section navigation (2)

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

From: Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp>
To: prakashn(at)uci(dot)edu
Cc: 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:34:32
Message-ID: 20000526103432U.t-ishii@sra.co.jp (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-hackers
> 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

In response to

pgsql-hackers by date

Next:From: Joe ShevlandDate: 2000-05-26 01:49:48
Subject: Re: [HACKERS] [DONE] PostgreSQL-7.0 binary for WinNT
Previous:From: Bruce MomjianDate: 2000-05-26 01:31:55
Subject: Re: Re: gram.y PROBLEM with UNDER

pgsql-bugs by date

Next:From: Toth IstvanDate: 2000-05-26 06:40:50
Subject: Soalris 8 install problems
Previous:From: Tom LaneDate: 2000-05-26 01:00:07
Subject: Re: \dS and \df <pattern> crashing psql

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group