Received: from mail-b.bcc.ac.uk (mail-b.bcc.ac.uk [144.82.100.22]) by hub.org (8.9.3/8.9.3) with ESMTP id HAA79686; Wed, 19 May 1999 07:01:28 -0400 (EDT) (envelope-from stuart@ludwig.ucl.ac.uk) Received: from kestrel.ludwig.ucl.ac.uk by mail-b.bcc.ac.uk with SMTP (XT-PP); Wed, 19 May 1999 12:00:12 +0100 Received: from [128.40.242.190] by kestrel.ludwig.ucl.ac.uk (SMI-8.6/SMI-SVR4) id MAA09534; Wed, 19 May 1999 12:00:01 +0100 Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" X-Sender: stuart@kestrel.ludwig.ucl.ac.uk Message-Id: Date: Wed, 19 May 1999 11:58:18 +0100 To: pgsql-general@postgresql.org, pgsql-interfaces@postgresql.org From: Stuart Rison Subject: Installing pl/pgsql under Irix 5.3 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' pl_gram.c sed -e 's/yy/plpgsql_yy/g' -e 's/YY/PLPGSQL_YY/g' 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' pl_gram.c sed -e 's/yy/plpgsql_yy/g' -e 's/YY/PLPGSQL_YY/g' 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 | stuart@ludwig.ucl.ac.uk | +-------------------------+--------------------------------------+