Re: [HACKERS] Backend 8.0.0B4 crash on SELECT ...

2004-11-05 Thread James Robinson
Patch applied, fixes beta4 for the query with our data. Many thanks again! James Robinson Socialserve.com ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [HACKERS] Backend 8.0.0B4 crash on SELECT ...

2004-11-05 Thread Tom Lane
James Robinson <[EMAIL PROTECTED]> writes: > I can reproduce a 8.0.0B4 backend crash on OSX 1.3.5. Fixed; thanks for the test case. If you need the patch right away, here it is. regards, tom lane *** src/backend/optimizer/path/indxpath.c.orig Mon Oct 11 18:56:56 2004 -

[HACKERS] Backend 8.0.0B4 crash on SELECT ...

2004-11-05 Thread James Robinson
I can reproduce a 8.0.0B4 backend crash on OSX 1.3.5. I can't even get it to analyze the query to get an idea of what the plan it is trying. What can I do to help diagnose what is going on? Here's the query: SELECT unit.id FROM unit WHERE unit.delete = 'f' AND unit.status=2 AND (