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

Re: ANALYSE on Solaris 8 bug

From: "Patrick Vachon" <kaleidelf(at)hotmail(dot)com>
To: tgl(at)sss(dot)pgh(dot)pa(dot)us
Cc: pgsql-ports(at)postgresql(dot)org
Subject: Re: ANALYSE on Solaris 8 bug
Date: 2003-06-30 20:11:01
Message-ID: BAY8-F56AaKHQ6mmqmz0000bb76@hotmail.com (view raw or flat)
Thread:
Lists: pgsql-ports
I initdb'ed with --no-locale option and that fixed the problem.
Thanks a lot Tom!

Should this issue be documented in src/doc/FAQ_Solaris?
IMHO, I think it should, since it may affect various versions of Solaris.

Regards,
Patrick

>From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
>To: "Patrick Vachon" <kaleidelf(at)hotmail(dot)com>
>CC: pgsql-ports(at)postgresql(dot)org
>Subject: Re: [PORTS] ANALYSE on Solaris 8 bug Date: Mon, 30 Jun 2003 
>12:54:40 -0400
>
>"Patrick Vachon" <kaleidelf(at)hotmail(dot)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
>
>---------------------------(end of broadcast)---------------------------
>TIP 8: explain analyze is your friend

_________________________________________________________________
Tired of spam? Get advanced junk mail protection with MSN 8.  
http://join.msn.com/?page=features/junkmail


Responses

pgsql-ports by date

Next:From: Tom LaneDate: 2003-06-30 20:28:09
Subject: Re: ANALYSE on Solaris 8 bug
Previous:From: Tom LaneDate: 2003-06-30 16:54:40
Subject: Re: ANALYSE on Solaris 8 bug

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