Re: [QUESTIONS] 6.2.1 COPY X FROM stdin; -- broken pipe

Started by Thomas G. Lockhartalmost 28 years ago2 messages
#1Thomas G. Lockhart
lockhart@alumni.caltech.edu
1 attachment(s)

oe> Try setting the environment variable LANG before starting the
oe> postmaster:
oe> $ export LANG=en_US
Unfortunately, this doesn't prevent the backend problem; the backend
still complains about the money format the and front-end gets a broken
pipe. Not sure what about the locale postgres doesn't like. For now,
I guess I'll just stick with my home-built version that doesn't use
the locale at all.

I tried this at my clean RH5.0 machine at work, with the RH5.0 rpm
installation of Postgres. It didn't help, and I guess I would have been
suprised if it did since the locale environment should have defaulted to
the "C" (same as "POSIX"?) conventions. I didn't get a backend crash,
just the usual symptom.

Didn't find a new Postgres package in Cristian's directory when I looked
this morning, but _did_ find a glibc2.0.7-2. Unfortunately it didn't seem
to fix the rounding problem in date/time. I stopped and restarted the
Postgres backend, but did not reboot the machine; was that sufficient?
Seems like 2.0.7-2 should have the features (and fixes) Oliver reported
for Debian, so don't know the story :(

My little test program, which also fails on my RH4.2 system, is included
below. It should return some characters related to locale; in this
version it tries the numeric decimal point (which does print) and the
money decimal point, which doesn't. Used to work, though as I mentioned
the code as it is currently may be damaged by my trial and error attempts
to get locale support working.

- Tom

Attachments:

testlocale.ctext/plain; charset=us-ascii; name=testlocale.cDownload
#2Cristian Gafton
gafton@redhat.com
In reply to: Thomas G. Lockhart (#1)
Re: [HACKERS] Re: [QUESTIONS] 6.2.1 COPY X FROM stdin; -- broken pipe

On Sat, 28 Feb 1998, Thomas G. Lockhart wrote:

Didn't find a new Postgres package in Cristian's directory when I looked
this morning, but _did_ find a glibc2.0.7-2. Unfortunately it didn't seem
to fix the rounding problem in date/time. I stopped and restarted the

I've put the packages on ftp://ftp.redhat.com/home/gafton/pgsql. For the
beta 6.3 I have put the regression test results too, so anybody can take a
look at them and comment.

Please take a look at the packages and tell me if there is something
missing from them (that is, things not installed by default by 'make
install' that ought to be included in a binary package though...

Best wishes,

Cristian
--
----------------------------------------------------------------------
Cristian Gafton -- gafton@redhat.com -- Red Hat Software, Inc.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
UNIX is user friendly. It's just selective about who its friends are.