From: | Guillaume LELARGE <gleu(at)wanadoo(dot)fr> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | server closed connection on a select query |
Date: | 2005-11-10 22:53:04 |
Message-ID: | 200511102353.04546.gleu@wanadoo.fr |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hi,
I've installed a 8.1.0 PostgreSQL server on a SCO OpenServer 5.0.6. It
seemed to work well with psql and such tools. I tried to connect to
this server with pgAdmin3 and a query failed. I tried to find which
part of the query was wrong and I have a strange result :
SELECT 1 FROM pg_language WHERE lanispl IS TRUE;
this one crashes the server.
SELECT 1 FROM pg_language WHERE lanispl = true;
works.
It seemed to me that "IS TRUE" is the culprit so I tried something else
SELECT lanispl IS TRUE FROM pg_language;
and it works.
If I create a table for testing purpose, I can add a where clause with
"IS TRUE".
Last thing I tried was to launch postgres on standalone. With the first query,
server crashed with a «Memory fault(coredump)». I can send you the all log if
you want.
This behavior happens on another server (SCO too) but not on any Linux
that I tried. I've attached the patch I apply to be able to build
PostgreSQL on SCO OpenServer. I'm not 100% sure it isn't faulty.
Did something like this already happened to someone ? Do you know of
any test I can do ?
Regards.
--
Guillaume.
<!-- http://abs.traduc.org/
http://lfs.traduc.org/
http://traduc.postgresqlfr.org/ -->
Attachment | Content-Type | Size |
---|---|---|
pg810.patch | text/x-diff | 3.8 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2005-11-10 23:10:37 | Re: generic builtin functions |
Previous Message | David Fetter | 2005-11-10 22:30:05 | Re: generic builtin functions |