Re: PG crash on simple query

"Maksim Likharev" <mlikharev(at)aurigin(dot)com> writes:
> 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's difficult to provide any advice when you haven't told us exactly
what the failure is nor shown the table definitions ...

> We run PG 7.3 on SunOS

I'd recommend an update to 7.3.3 on general principles, but it's
impossible to guess whether that would fix the problem for you.

regards, tom lane