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@sss.pgh.pa.us>
>To: "Patrick Vachon" <kaleidelf@hotmail.com>
>CC: pgsql-ports@postgresql.org
>Subject: Re: [PORTS] ANALYSE on Solaris 8 bug Date: Mon, 30 Jun 2003
>12:54:40 -0400
>
>"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
>
>---------------------------(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