Обсуждение: 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
you have some sort of a problem? <http://archives.postgresql.org/pgsql-admin/> "This is a general discussion area for users pertaining to the administration, compilation and installation of PostgreSQL" --On Sunday, March 16, 2003 11:39 AM -0700 Rich Burgi <ts-rrb@orem.verio.net> wrote: > who cares.... get me off this list!!!!!! > > On Sun, 16 Mar 2003, R Blake 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 >> >> ---------------------------(end of broadcast)--------------------------- >> TIP 3: if posting/reading through Usenet, please send an appropriate >> subscribe-nomail command to majordomo@postgresql.org so that your >> message can get through to the mailing list cleanly >> > -------------------------------------- R Blake blakers <at> mac <dot> com -------------------------------------- MacOSX ..... because Windows sux. --------------------------------------
> 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: >> 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 >