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

[yamt%NetBSD.org@localhost]

>Number:         44365
>Category:       pkg
>Synopsis:       postgresql90: plpgsql doesn't work on osx
>Confidential:   no
>Severity:       serious
>Priority:       medium
>Responsible:    pkg-manager
>State:          open
>Class:          sw-bug
>Submitter-Id:   net
>Arrival-Date:   Mon Jan 10 00:05:00 +0000 2011
>Originator:     YAMAMOTO Takashi
>Release:        pkgsrc current
>Organization:
        
>Environment:
        
        
System: Darwin gindara.lan 10.6.0 Darwin Kernel Version 10.6.0: Wed Nov 10 
18:13:17 PST 2010; root:xnu-1504.9.26~3/RELEASE_I386 i386
Architecture: i386
Machine: i386
>Description:
        see the following.  i'm using postgresql90-9.0.2-* from
        pkgsrc.  it seems to make the server process die with SIGBUG.
        i guess this is a pkgsrc problem because a 9.0.2 binary
        from enterprisedb.com works without the problem.
        (http://www.enterprisedb.com/products/pgdownload.do#osx)

gindara% psql
psql (9.0.2)
Type "help" for help.

takashi=# create function hoge ( a int, b int) returns int as $$
takashi$# begin
takashi$# return a+b;
takashi$# end;
takashi$# $$ language plpgsql;
WARNING:  trying to insert a function that already exists
CONTEXT:  compilation of PL/pgSQL function "hoge" near line 1
CREATE FUNCTION
takashi=# 

>How-To-Repeat:
        
>Fix:
        

>Unformatted: