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

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:

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: