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

[Adam <adam%NetBSD.org@localhost>]

The following reply was made to PR pkg/44365; it has been noted by GNATS.

From: Adam <adam%NetBSD.org@localhost>
To: gnats-bugs%NetBSD.org@localhost
Cc: pkg-manager%netbsd.org@localhost,
 pkgsrc-bugs%netbsd.org@localhost,
 gnats-admin%netbsd.org@localhost,
 obache%NetBSD.org@localhost,
 yamt%NetBSD.org@localhost
Subject: Re: pkg/44365 (postgresql90: plpgsql doesn't work on osx)
Date: Thu, 13 Jan 2011 13:30:56 +0100

 > 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 =3D 0x2a03, stop reason =3D EXC_BAD_ACCESS (code=3D1, =
 address=3D0x1a1)
 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.