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: (view raw, whole thread or download thread mbox)
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.


>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 
> > 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.


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-2017 The PostgreSQL Global Development Group