[HACKERS] postmaster core dump

2005-09-19 Thread Patrick Welche
I seem to have an unhappy postgresql: (gdb) bt #0 0xbd99871b in kill () from /usr/lib/libc.so.12 #1 0xbda217e7 in abort () from /usr/lib/libc.so.12 #2 0x0820c1fa in ExceptionalCondition ( conditionName=0x8298920 !(batchno hashtable-curbatch), errorType=0x823919f FailedAssertion,

Re: [HACKERS] postmaster core dump

2005-09-19 Thread Patrick Welche
On Mon, Sep 19, 2005 at 06:12:54PM +0100, Patrick Welche wrote: #15 0x081a4c2f in exec_simple_query ( query_string=0x834501c select timesliced, count(stats_id) from trans left j I just truncated one line early.. the query was: # explain select timesliced, count(stats_id) from trans left

Re: [HACKERS] postmaster core dump

2005-09-19 Thread Tom Lane
Patrick Welche [EMAIL PROTECTED] writes: I seem to have an unhappy postgresql: Let's see a test case, not a stack trace. regards, tom lane ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your

Re: [HACKERS] postmaster core dump

2005-09-19 Thread Patrick Welche
On Mon, Sep 19, 2005 at 03:59:35PM -0400, Tom Lane wrote: Patrick Welche [EMAIL PROTECTED] writes: I seem to have an unhappy postgresql: Let's see a test case, not a stack trace. I haven't set up the minimalist test case yet, but the 2 tables involved are incredibly simple. stats.id is an