Postgres Pro
Downloads
Home   >   mailing lists

Re: Join query crashes 7.3.1 backend... - Mailing list pgsql-general

From Tom Lane
Subject Re: Join query crashes 7.3.1 backend...
Date
Msg-id 10509.1046186235@sss.pgh.pa.us
Whole thread Raw
In response to Join query crashes 7.3.1 backend...  ("Mark Cave-Ayland" <m.cave-ayland@webbased.co.uk>)
List pgsql-general
Tree view 
"Mark Cave-Ayland" <m.cave-ayland@webbased.co.uk> writes:
> I'm having a problem executing a join query which causes the postgresql
> backend to crash.

Please try 7.3.2.   There's a (longstanding) overflow problem in the
hash join code that only triggers on sufficiently large input sets.
It was detected and fixed a couple months ago...

            regards, tom lane

pgsql-general by date:

Previous
From: Philippe Kiener
Date:
Subject: Re: How do I change the server encoding?
Next
From: Tom Lane
Date:
Subject: Re: error compiling 7.3.2 on solaris 8- library conflict