Обсуждение: anyone? 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

> the command:
> 
>         createlang --pglib=/usr/local/pgsql/lib --dbname=apache_auth
> plpgsql

Try just this:

createlang plpgsql apache_auth

Chris

--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 ..... :-(

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

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
>