Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 2D5A21335B36 for ; Fri, 19 Nov 2010 20:22:21 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 73445-02 for ; Sat, 20 Nov 2010 00:22:13 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from qmta14.westchester.pa.mail.comcast.net (qmta14.westchester.pa.mail.comcast.net [76.96.59.212]) by mail.postgresql.org (Postfix) with ESMTP id 88A45133655C for ; Fri, 19 Nov 2010 20:22:13 -0400 (AST) Received: from omta06.westchester.pa.mail.comcast.net ([76.96.62.51]) by qmta14.westchester.pa.mail.comcast.net with comcast id Z8x31f00B16LCl05ECNDSS; Sat, 20 Nov 2010 00:22:13 +0000 Received: from sz0093.wc.mail.comcast.net ([76.96.58.151]) by omta06.westchester.pa.mail.comcast.net with comcast id ZCND1f00L3FmDic3SCNDqa; Sat, 20 Nov 2010 00:22:13 +0000 Date: Sat, 20 Nov 2010 00:22:13 +0000 (UTC) From: Lou Picciano To: pgsql-admin Message-ID: <2053594345.829727.1290212533738.JavaMail.root@sz0093a.westchester.pa.mail.comcast.net> Subject: Building pl/plsh - Shell scripting from PG v9.0.1? MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_829726_636304794.1290212533737" X-Originating-IP: [68.39.28.247] X-Mailer: Zimbra 6.0.5_GA_2431.RHEL5_64 (ZimbraWebClient - SAF3 (Mac)/6.0.5_GA_2427.RHEL4) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-0.927 tagged_above=-10 required=5 tests=BAYES_00=-1.9, HTML_FONT_FACE_BAD=0.981, HTML_MESSAGE=0.001, RCVD_IN_DNSWL_NONE=-0.0001, RFC_ABUSE_POST=0.001, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201011/155 X-Sequence-Number: 36121 ------=_Part_829726_636304794.1290212533737 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit PG Wizards: I wonder if any of you has had luck building plpgsh on a v9.0.1 build of PostgreSQL? Platform is x86 openIndiana. Perhaps I'm the first? This simple configure seems to work: # ./configure prefix=/usr/local/pgsql/901 PG_CONFIG=/usr/local/pgsql/901/bin/pg_config But build hiccups: (cd .libs && rm -f pgplsh.la && ln -s ../pgplsh.la pgplsh.la) . pgplsh.la && sed "s,%filename%,/usr/local/pgsql/901/lib/pgplsh/$dlname,g" ./createlang_pgplsh.sql.in >createlang_pgplsh.sql /bin/sh[1]: .: pgplsh.la: cannot open [No such file or directory] make: *** [createlang_pgplsh.sql] Error 1 I'm sure one of you can look at it and realize what's wrong. I'm going to start digging through the Makefile later tonight, but thought I'd try here first. We're eager to try some bash scripting from - and back to - PostgreSQL. Many Thanks, Lou Picciano ------=_Part_829726_636304794.1290212533737 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable <= div style=3D'font-family: Verdana; font-size: 12pt; color: #000000'>PG Wiza= rds:

I wonder if any of you has had luck building p= lpgsh on a v9.0.1 build of PostgreSQL?
Platform is x86 openIndian= a. Perhaps I'm the first?

This simple configure se= ems to work:

# ./configure pr= efix=3D/usr/local/pgsql/901 PG_CONFIG=3D/usr/local/pgsql/901/bin/pg_config<= /font>

But build hiccups:

(cd .libs && rm -f pgplsh.la && = ln -s ../pgplsh.la pgplsh.la)
.  = ;pgplsh.la && sed "s,%filename%,/usr/local/pgsql/901/lib/pgplsh/$dl= name,g" ./createlang_pgplsh.sql.in >createlang_pgplsh.sql
/bin/sh[1]: .: pgplsh.la: cannot open [No such file= or directory]
make: *** [createlang_= pgplsh.sql] Error 1

I'm sure one of y= ou can look at it and realize what's wrong. I'm going to start digging thro= ugh the Makefile later tonight, but thought I'd try here first.
<= br>
We're eager to try some bash scripting from - and back to - P= ostgreSQL.

Many Thanks, Lou Picciano
------=_Part_829726_636304794.1290212533737--