hi,

i've successfully installed Postgresql 7.3.2 on Mac OSX 10.2.4, and can 
access/administer as necessary

except, i can't seem to CREATELANG, specifically plpgsql .....

the command:

        createlang --pglib=/usr/local/pgsql/lib --dbname=apache_auth plpgsql

simply returns:

ERROR:  Load of file /usr/local/pgsql/lib/plpgsql.dylib failed: no error 
message available
createlang: language installation failed


my LOG file has nothing further:

...
LOG:  database system is ready
ERROR:  Load of file /usr/local/pgsql/lib/plpgsql.dylib failed: no error 
message available



"no error message" is not very helpful  :-(

i tried a clean install -- all went without a hitch .....

anyone have any suggestions here?


thanks!

richard

Sun, 16 Mar 2003 09:16:52 -0800
R Blake <blakers@mac.com>
CREATELANG in pgsql 7.3.2 failing
>         createlang --pglib=/usr/local/pgsql/lib --dbname=apache_auth plpgsql
> 
> simply returns:
> 
> ERROR:  Load of file /usr/local/pgsql/lib/plpgsql.dylib failed: no error 
> message available
> createlang: language installation failed

I suspect that plpgsql.dylib wasn't there in /usr/local/pgsql/lib/, try to 
locate the file and specify --pglib param appropriately.

regards,
bhuvaneswaran


Mon, 17 Mar 2003 10:53:50 +0530 (IST)
"A.Bhuvaneswaran" <bhuvansql@myrealbox.com>
Re: CREATELANG in pgsql 7.3.2 failing
thanks for your reply, but, nope, that was the first thing i checked.

definitely there, and a freshly built copy ....

and, from what i've tracked down , that would've generated a "file not 
found" error ....

i'm suspicious -- but still tumped -- of that "no error message available" 
message ...

richard

--On Monday, March 17, 2003 10:53 AM +0530 "A.Bhuvaneswaran" 
<bhuvansql@myrealbox.com> wrote:

>>         createlang --pglib=/usr/local/pgsql/lib --dbname=apache_auth
>>         plpgsql
>>
>> simply returns:
>>
>> ERROR:  Load of file /usr/local/pgsql/lib/plpgsql.dylib failed: no error
>> message available
>> createlang: language installation failed
>
> I suspect that plpgsql.dylib wasn't there in /usr/local/pgsql/lib/, try
> to  locate the file and specify --pglib param appropriately.
>
> regards,
> bhuvaneswaran
>


Sun, 16 Mar 2003 21:32:24 -0800
R Blake <blakers@mac.com>
Re: CREATELANG in pgsql 7.3.2 failing
hi,

i've successfully installed Postgresql 7.3.2 on Mac OSX 10.2.4, and can
access/administer as necessary

except, i can't seem to CREATELANG, specifically plpgsql .....

the command:

        createlang --pglib=/usr/local/pgsql/lib --dbname=apache_auth
plpgsql

simply returns:

ERROR:  Load of file /usr/local/pgsql/lib/plpgsql.dylib failed: no error
message available createlang: language installation failed


my LOG file has nothing further:

...
LOG:  database system is ready
ERROR:  Load of file /usr/local/pgsql/lib/plpgsql.dylib failed: no error
message available



"no error message" is not very helpful  :-(

i tried a clean install -- all went without a hitch .....

anyone have any suggestions here?


thanks!

richard

Mon, 17 Mar 2003 19:52:32 -0800
R Blake <blakers@mac.com>
anyone? CREATELANG in pgsql 7.3.2 failing
> the command:
> 
>         createlang --pglib=/usr/local/pgsql/lib --dbname=apache_auth
> plpgsql

Try just this:

createlang plpgsql apache_auth

Chris


Tue, 18 Mar 2003 12:22:12 +0800
"Christopher Kings-Lynne" <chriskl@familyhealth.com.au>
Re: anyone? CREATELANG in pgsql 7.3.2 failing
--On Tuesday, March 18, 2003 12:22 PM +0800 Christopher Kings-Lynne 
<chriskl@familyhealth.com.au> wrote:

> Try just this:
>
> createlang plpgsql apache_auth
>
> Chris
hi!

ok, but i wouldn't expect the result to be any different ....

here we go .....

[postgres@g4]/usr/local/pgsql/lib> createlang plpgsql apache_auth
ERROR:  Load of file /usr/local/pgsql/lib/plpgsql.dylib failed: no error 
message available
createlang: language installation failed
[postgres@g4]/usr/local/pgsql/lib>

same problem, same error ..... :-(



Mon, 17 Mar 2003 22:02:00 -0800
R Blake <blakers@mac.com>
Re: anyone? CREATELANG in pgsql 7.3.2 failing
R Blake writes:

> ERROR:  Load of file /usr/local/pgsql/lib/plpgsql.dylib failed: no error
> message available createlang: language installation failed

The fact that the file extension is ".dylib" makes me suspicious that you
are using a patched version.  In the original source the extension is
".so".  If you, or someone you know, has attempted to modify the shared
library build system, please fix it.

-- 
Peter Eisentraut   peter_e@gmx.net


Tue, 18 Mar 2003 23:03:59 +0100 (CET)
Peter Eisentraut <peter_e@gmx.net>
Re: anyone? CREATELANG in pgsql 7.3.2 failing
bingo! nice catch!

after a little sleuthing, the local CVS source copy DID have a series of 
".dylib-handling" patches applied .... (have to revisit local naming 
conventions ....)

a virgin refresh with 7.3.2-STABLE solved the plpgsql issue.  thanks!!

altho, --with-java now breaks the build ..... without it all is ok

but that's another issue for now ....

many thanks!

richard

-- On Tuesday, March 18, 2003 11:03 PM +0100  Peter Eisentraut 
<peter_e@gmx.net> wrote:


> R Blake writes:
>
>> ERROR:  Load of file /usr/local/pgsql/lib/plpgsql.dylib failed: no error
>> message available createlang: language installation failed
>
> The fact that the file extension is ".dylib" makes me suspicious that you
> are using a patched version.  In the original source the extension is
> ".so".  If you, or someone you know, has attempted to modify the shared
> library build system, please fix it.
>
> --
> Peter Eisentraut   peter_e@gmx.net
>


Tue, 18 Mar 2003 15:17:09 -0800
R Blake <blakers@mac.com>
Re: anyone? CREATELANG in pgsql 7.3.2 failing