pkg/25473: Postgresql-7.3.2 fails to load languages on netbsd-1.6/cobalt

[bservies%pacang.com@localhost]

>Number:         25473
>Category:       pkg
>Synopsis:       Postgresql-7.3.2 fails to load languages on netbsd-1.6/cobalt
>Confidential:   no
>Severity:       serious
>Priority:       medium
>Responsible:    pkg-manager
>State:          open
>Class:          sw-bug
>Submitter-Id:   net
>Arrival-Date:   Wed May 05 16:25:00 UTC 2004
>Closed-Date:
>Last-Modified:
>Originator:     Byron Servies
>Release:        NetBSD 1.6.2
>Organization:
        Self
>Environment:
System: NetBSD piglet.central 1.6.2 NetBSD 1.6.2 (BYRON) #1: Mon Mar 1 21:23:26 
PST 2004 root%piglet.central@localhost:/usr/src/sys/arch/cobalt/compile/BYRON 
cobalt
Architecture: mipsel
Machine: cobalt
>Description:
        After building postgresql-7.3.2 from pkgsrc I attempted to add
        the plpgsql scripting language to the database using the command:

        $ createlang plpgsql template1
        ERROR:  Load of file /usr/pkg/lib/postgresql/plpgsql.so failed: dlopen 
(/usr/pkg/lib/postgresql/plpgsql.so) not supported
        createlang: language installation failed

        Investigating this problem, I found that the dynaloader.c file (which
        abstracts dlopen, etc., calls) contained blocks of "if 
defined(__mips__)"
        that print the 'not supported' error and return a fault instead of
        calling dlopen.

>How-To-Repeat:
        Build postgresql and attempt to load the language as shown above.
        Note that I am running a kernel with the following settings for
        semaphores so that postgres will start:
        options       SEMMNI=2000     # number of semaphore identifiers
        options       SEMMNS=12000    # number of semaphores in system
        options       SEMUME=2000     # max number of undo entries per process
        options       SEMMNU=6000     # number of undo structures in system
>Fix:
        I replaced these with "ifndef HAVE_DLOPEN" and rebuilt.  The database
        now loads languages and passes nearly all the provided regression
        tests (which would not run before because they required the plpgsql
        language).
>Release-Note:
>Audit-Trail:
>Unformatted: