Dear all, I'm having trouble installing PL/pgSQL under Irix 5.3. at first gmake gave me the following error message: merlin::postgres 52% gmake cc -I../../../include -I../../../backend -I../../../interfaces/libpq -I../../../include -I../../../backend -c -o pl_parse.o pl_gram.c cfe: Error: gram.y: 1460: Cannot open file pl_scan.c for #include gmake: *** [pl_parse.o] Error 1 In desperation, I tried to comment out the #include line in gram.y and got: merlin::postgres 52% gmake /usr/bin/yacc -d gram.y mv -f y.tab.c gram.c sed -e 's/yy/plpgsql_yy/g' -e 's/YY/PLPGSQL_YY/g' <gram.c >pl_gram.c sed -e 's/yy/plpgsql_yy/g' -e 's/YY/PLPGSQL_YY/g' <y.tab.h >pl.tab.h cc -I../../../include -I../../../backend -I../../../interfaces/libpq -I../../../include -I../../../backend -c -o pl_parse.o pl_gram.c cfe: Error: gram.y, line 1460: Syntax Error //#include "pl_scan.c" ^ cfe: Error: gram.y, line 1460: Unknown character # ignored //#include "pl_scan.c" --^ gmake: *** [pl_parse.o] Error 1 But because the install went slightly further, I decided to retry gmake (of course removing the offending comment marks): gmake /usr/bin/yacc -d gram.y mv -f y.tab.c gram.c sed -e 's/yy/plpgsql_yy/g' -e 's/YY/PLPGSQL_YY/g' <gram.c >pl_gram.c sed -e 's/yy/plpgsql_yy/g' -e 's/YY/PLPGSQL_YY/g' <y.tab.h >pl.tab.h cc -I../../../include -I../../../backend -I../../../interfaces/libpq -I../../../include -I../../../backend -c -o pl_parse.o pl_gram.c cc -I../../../include -I../../../backend -I../../../interfaces/libpq -I../../../include -I../../../backend -c pl_handler.c -o pl_handler.o cc -I../../../include -I../../../backend -I../../../interfaces/libpq -I../../../include -I../../../backend -c pl_comp.c -o pl_comp.o cc -I../../../include -I../../../backend -I../../../interfaces/libpq -I../../../include -I../../../backend -c pl_exec.c -o pl_exec.o cc -I../../../include -I../../../backend -I../../../interfaces/libpq -I../../../include -I../../../backend -c pl_funcs.c -o pl_funcs.o ar crs libplpgsql.a pl_parse.o pl_handler.o pl_comp.o pl_exec.o pl_funcs.o /usr/lib/ar: Warning:ignoring second definition of fmgr_pl_finfo defined in archive /usr/lib/ar: Warning:ignoring second definition of fmgr_pl_finfo defined in archive /usr/lib/ar: Warning:ignoring second definition of fmgr_pl_finfo defined in archive /usr/lib/ar: Warning:ignoring second definition of fmgr_pl_finfo defined in archive Result I thought, until I tried gmake install: merlin::root 1# gmake install plpgsql not installed due to lack of shared library support. What do I try next? (Irix 5.3, psSQL 6.4). Regards, Stuart. +-------------------------+--------------------------------------+ | Stuart Rison | Ludwig Institute for Cancer Research | +-------------------------+ 91 Riding House Street | | Tel. (0171) 878 4041 | London, W1P 8BT, UNITED KINGDOM. | | Fax. (0171) 878 4040 | [EMAIL PROTECTED] | +-------------------------+--------------------------------------+
