Re: pgsql: Add new contrib function pgrowlocks.

On Sat, Apr 22, 2006 at 10:12:58PM -0300, Tatsuo Ishii wrote:
> Log Message:
> -----------
> Add new contrib function pgrowlocks. See README.pgrowlocks for more details.

Calling this function results in SIGBUS on Solaris 9/sparc.

test=> CREATE TABLE foo (id integer);
CREATE TABLE
test=> SELECT * FROM pgrowlocks('foo');
server closed the connection unexpectedly

% gdb bin/postgres data/core
[...]
Program terminated with signal 10, Bus error.
[...]
(gdb) bt
#0 UnlockRelation (relation=0x7f7f7f7f, lockmode=1) at lmgr.c:126
#1 0x0005aeb8 in relation_close (relation=0x7f7f7f7f, lockmode=1) at heapam.c:786
#2 0xfee90d4c in pgrowlocks (fcinfo=0xffbfe238) at pgrowlocks.c:225
#3 0x00115830 in ExecMakeTableFunctionResult (funcexpr=0x3e0068, econtext=0x3df958, expectedDesc=0x3dfc10, returnDesc=0xffbfe4b4) at execQual.c:1305
#4 0x00125160 in FunctionNext (node=0x3df8c8) at nodeFunctionscan.c:71
#5 0x001199d4 in ExecScan (node=0x3df8c8, accessMtd=0x1250f4 <FunctionNext>) at execScan.c:68
#6 0x00113a30 in ExecProcNode (node=0x3df8c8) at execProcnode.c:366
#7 0x00112928 in ExecutorRun (queryDesc=0x3df8c8, direction=ForwardScanDirection, count=0) at execMain.c:1144
#8 0x001acacc in PortalRunSelect (portal=0x3dd2f8, forward=1 '\001', count=0, dest=0x3d1670) at pquery.c:804
#9 0x001ad314 in PortalRun (portal=0x3dd2f8, count=2147483647, dest=0x3d1670, altdest=0x3d1670, completionTag=0xffbfe860 "") at pquery.c:621
#10 0x001a8414 in exec_simple_query (query_string=0x3d0e40 "SELECT * FROM pgrowlocks('foo');") at postgres.c:1017
#11 0x001a9dc4 in PostgresMain (argc=4, argv=0x382510, username=0x3824e0 "mfuhr") at postgres.c:3250
#12 0x0017c364 in ServerLoop () at postmaster.c:2915
#13 0x0017e4f4 in PostmasterMain (argc=0, argv=0x357ac0) at postmaster.c:980
#14 0x00135880 in main (argc=3, argv=0x357ac0) at main.c:254

--
Michael Fuhr