Re: ANALYSE on Solaris 8 bug - Mailing list pgsql-ports

From Tom Lane
Subject Re: ANALYSE on Solaris 8 bug
Date
Msg-id 15432.1056992080@sss.pgh.pa.us
Whole thread Raw
In response to ANALYSE on Solaris 8 bug  ("Patrick Vachon" <kaleidelf@hotmail.com>)
List pgsql-ports
"Patrick Vachon" <kaleidelf@hotmail.com> writes:
> Solaris 8
> PostgreSQL-7.3.3

> After doing an ANALYSE command, any equality comparison between two string
> fields from different table failed and make the server restart.

If you are running in a non-C locale, you might see whether the problem
goes away after re-initdb'ing in C locale.  I have some recollection of
strcoll() having bugs in various versions of Solaris.  It'd be worth
trying to get a stack trace out of the core dump file to verify where
it's crashing, too.

            regards, tom lane

pgsql-ports by date:

Previous
From: "Patrick Vachon"
Date:
Subject: ANALYSE on Solaris 8 bug
Next
From: "Patrick Vachon"
Date:
Subject: Re: ANALYSE on Solaris 8 bug