Re: ANALYSE on Solaris 8 bug

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