"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