PG crash on simple query

From: "Maksim Likharev" <mlikharev(at)aurigin(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: PG crash on simple query
Date: 2003-06-29 08:44:15
Message-ID: 56510AAEF435D240958D1CE8C6B1770A016D2D74@mailc03.aurigin.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Shridhar Daithankar 2003-06-29 08:56:45 Re: [HACKERS] Physical Database Configuration
Previous Message Toni Schlichting 2003-06-29 08:41:36 Re: How many fields in a table are too many