PG crash on simple query - Mailing list pgsql-general

From Maksim Likharev
Subject PG crash on simple query
Date
Msg-id 56510AAEF435D240958D1CE8C6B1770A016D2D74@mailc03.aurigin.com
Whole thread Raw
Responses Re: PG crash on simple query  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Hi,
I have consistent PG crash on some query,
so I was able to isolate a simple query that crash postgres...

SELECT p.docid FROM prod.t_documents AS p
INNER JOIN t_tempdocs AS t
    ON p.docid = t.docid
        LEFT OUTER JOIN prod.t_refs AS ct
            ON ct.docid = p.docid;

It seems like any reference to prod.t_refs lead to that.

We run PG 7.3 on SunOS

Is there any particular steps to follow in order to resolve this.
Thank you.

pgsql-general by date:

Previous
From: Toni Schlichting
Date:
Subject: Re: How many fields in a table are too many
Next
From: Shridhar Daithankar
Date:
Subject: Re: [HACKERS] Physical Database Configuration