pkgsrc-Bugs archive

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index][Old Index]

Re: pkg/44365 (postgresql90: plpgsql doesn't work on osx)



> Synopsis: postgresql90: plpgsql doesn't work on osx

This is a good one!

The problem does not only affect 9.0.2, but other PostgreSQL versions as well.
I debugged the code and found out that the crash occurs in 
plpgsql_HashTableLookup function from pl_comp.c.
Here is the dump log:

thread #1: tid = 0x2a03, stop reason = EXC_BAD_ACCESS (code=1, address=0x1a1)
frame #0: 0x0000000100e4d1ac plpgsql.0.so`plpgsql_HashTableLookup + 54 at 
pl_comp.c:2407
frame #1: 0x0000000100e48b8b plpgsql.0.so`plpgsql_compile + 279 at pl_comp.c:165
frame #2: 0x0000000100e47cfa plpgsql.0.so`plpgsql_call_handler + 110 at 
pl_handler.c:104
frame #3: 0x000000010017db57 postgres`ExecMakeFunctionResult + 1833 at 
execQual.c:1827
frame #4: 0x000000010017e66b postgres`ExecEvalFunc + 109 at execQual.c:2263
frame #5: 0x0000000100185212 postgres`ExecTargetList + 205 at execQual.c:5089
frame #6: 0x000000010018584b postgres`ExecProject + 806 at execQual.c:5304
frame #7: 0x000000010019b7c9 postgres`ExecResult + 317 at nodeResult.c:155
frame #8: 0x000000010017a172 postgres`ExecProcNode + 287 at execProcnode.c:355
frame #9: 0x0000000100177ffb postgres`ExecutePlan + 101 at execMain.c:1190
frame #10: 0x0000000100176ac6 postgres`standard_ExecutorRun + 289 at 
execMain.c:280
frame #11: 0x00000001001769a0 postgres`ExecutorRun + 74 at execMain.c:229
frame #12: 0x000000010029393d postgres`PortalRunSelect + 219 at pquery.c:952
frame #13: 0x000000010029356d postgres`PortalRun + 594 at pquery.c:796
frame #14: 0x000000010028cb5e postgres`exec_simple_query + 1111 at 
postgres.c:1058
frame #15: 0x00000001002916f8 postgres`PostgresMain + 2304 at postgres.c:3929
frame #16: 0x00000001001bc5f8 postgres`main + 541 at main.c:186
frame #17: 0x00000001000017b4 postgres`start + 52

2404                                                                            
 HASH_FIND,
2405                                                                            
 NULL);
2406            if (hentry)
2407 ->                 return hentry->function;
2408            else
2409                    return NULL;
2410    }

Everything's fine when PostgreSQL is built _without_ libtool.



Home | Main Index | Thread Index | Old Index