Received: from virtuel.qc.ca (virtuel.qc.ca [207.96.141.2]) by hub.org (8.9.3/8.9.3) with SMTP id VAA64646 for ; Fri, 20 Aug 1999 21:10:55 -0400 (EDT) (envelope-from hostmaster@virtuel.qc.ca) Received: from maximum [207.96.141.5] by virtuel.qc.ca (SMTPD32-4.07) id AC3FC3D00EE; Fri, 20 Aug 1999 21:09:19 EDT Message-ID: <001901beeb72$040ad350$058d60cf@virtuel.qc.ca> From: "Nicolas Cadou" To: "pgsql-sql list" References: <199908201918.MAA31413@uno.tksoft.com> Subject: Re: [SQL] Missing PL/pgSQL library Date: Fri, 20 Aug 1999 21:10:53 -0400 Organization: Internet au Virtuel Inc. MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.2314.1300 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300 Hi, I installed those packages: postgresql-6.5.1-1.i386.rpm postgresql-clients-6.5-1.beta1.i386.rpm postgresql-devel-6.5.1-1.i386.rpm postgresql-jdbc-6.5.1-1.i386.rpm postgresql-odbc-6.5.1-1.i386.rpm postgresql-perl-6.5.1-1.i386.rpm postgresql-python-6.5.1-1.i386.rpm postgresql-server-6.5.1-1.i386.rpm postgresql-tcl-6.5.1-1.i386.rpm I did this from the directory where those files are, as root: rpm -qlp postgresql* | grep 'plpgsql' There was not output. With a grep 'so' there is 53 lines of output, but nothing that looks like the library I'm looking for Nicolas Cadou ----- Original Message ----- From: To: Nicolas Cadou Sent: Friday, August 20, 1999 15:18 Subject: Re: [SQL] Missing PL/pgSQL library > Nicolas, > > I have no idea what's in which RPMS, but my guess is > you also need the "dev" version of the RPM, since RPMS are > usually split into a user and development version. > > If this is the solution, would you mind sending a note > to the list, so other people know? > > Cheers, > > Troy > > > > > > > [PostgreSQL 6.5.1 on i686-pc-linux-gnu, compiled by gcc 2.7.2.3] > > > > Hi, > > > > I installed the PostgreSQL 6.5.1-1 RPM packages that I downloaded from > > ftp://postgresql.nextpath.com/pub/postgresql/RPMS/ > > > > I then tried to make PL/pgSQL to work by typing in psql, as the postgres > > user, in the 'template1' database, these statements from the PostgreSQL > > Programmer's Guide, Chapter 43. Procedural Languages > > > > CREATE FUNCTION plpgsql_call_handler () RETURNS OPAQUE AS > > '/usr/local/pgsql/lib/plpgsql.so' LANGUAGE 'C'; > > > > CREATE TRUSTED PROCEDURAL LANGUAGE 'plpgsql' > > HANDLER plpgsql_call_handler > > LANCOMPILER 'PL/pgSQL'; > > > > It worked with 6.4.2, but with 6.5.1 it complains about > > '/usr/local/pgsql/lib/plpgsql.so' being not found. I did a 'find / -name > > plpgsql.so' as root and didn't find that file. In fact the directory > > '/usr/local/pgsql' doesn't even exists. So I listed the files in the eight > > RPMs and found that plpgsql.so is not in any of them. What am I missing? Can > > you help me with this? > > > > Thank you for your time > > > > Nicolas Cadou > > > > > > > > > > ************ > > > > > >