Re: Your application

See the attached file for details
>From pgsql-ports-owner(at)postgresql(dot)org Fri Aug 22 12:06:30 2003
X-Original-To: pgsql-ports-postgresql(dot)org(at)localhost(dot)postgresql(dot)org
Received: from localhost (unknown [64.117.224.130])
by svr1.postgresql.org (Postfix) with ESMTP id EF2DFD1B8DF
for <pgsql-ports-postgresql(dot)org(at)localhost(dot)postgresql(dot)org>; Fri, 22 Aug 2003 12:06:24 -0300 (ADT)
Received: from svr1.postgresql.org ([64.117.224.193])
by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024)
with ESMTP id 61919-09
for <pgsql-ports-postgresql(dot)org(at)localhost(dot)postgresql(dot)org>;
Fri, 22 Aug 2003 12:05:58 -0300 (ADT)
Received: from hotmail.com (bay8-f76.bay8.hotmail.com [64.4.27.76])
by svr1.postgresql.org (Postfix) with ESMTP id C3AD2D1B56C
for <pgsql-ports(at)postgresql(dot)org>; Fri, 22 Aug 2003 12:05:52 -0300 (ADT)
Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC;
Fri, 22 Aug 2003 08:05:57 -0700
Received: from 216.94.157.147 by by8fd.bay8.hotmail.msn.com with HTTP;
Fri, 22 Aug 2003 15:05:57 GMT
X-Originating-IP: [216.94.157.147]
X-Originating-Email: [kaleidelf(at)hotmail(dot)com]
From: "Patrick Vachon" <kaleidelf(at)hotmail(dot)com>
To: pgsql-ports(at)postgresql(dot)org
Subject: Fwd: ANALYSE on Solaris 8 bug
Date: Fri, 22 Aug 2003 15:05:57 +0000
Mime-Version: 1.0
Content-Type: text/plain; format=flowed
Message-ID: <BAY8-F763TGJ2TUSzbA000052b4(at)hotmail(dot)com>
X-OriginalArrivalTime: 22 Aug 2003 15:05:57.0153 (UTC) FILETIME=[E3CE5110:01C368BE]
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200308/17
X-Sequence-Number: 1543

Hi,

For those who had similar problem than me, release 7.3.4 fix my problem.
Thanks,
Patrick

>From: "Patrick Vachon" <kaleidelf(at)hotmail(dot)com>
>To: pgsql-ports(at)postgresql(dot)org
>Subject: [PORTS] ANALYSE on Solaris 8 bug
>Date: Mon, 30 Jun 2003 15:24:48 +0000
>
>Patrick Vachon
>kaleidelf AT hotmail.com
>
>SPARC Sun Blade 100
>Solaris 8
>PostgreSQL-7.3.3
>gcc 2.95.3
>compiled with readline and fuzzystrmatch without error.
>
>After doing an ANALYSE command, any equality comparison between two string
>fields from different table failed and make the server restart.
>The PostgreSQL server complains about a shared memory error and panics.
>The database was exported from 7.2.1 using a custom format dump, and
>restored into 7.3.3.
>
>It is always reproducible anytime after the database was restored using:
>mydb=# analyse;
>mydb=# select * from tableA join tableB using (pkeyIntID) where
>tableA.varcharField = tableB.varcharField;
>-> connection dropped, server restarted
>-> #! prompt appears
>
>There is an unique btree index on (pkeyIntID, varcharField) defined on both
>tables.
>I tried to rebuild database indexes, vacuum full, vacuum analyse, in many
>combinaisons, it changed nothing, the bug was still there.
>So, anybody has a clue?
>If you need more information, just let me know.
>Thanks a lot,
>Patrick

_________________________________________________________________
MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*.
http://join.msn.com/?page=features/virus