Thread: 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 >