Received: from virtuel.qc.ca (virtuel.qc.ca [207.96.141.2]) by hub.org (8.9.3/8.9.3) with SMTP id QAA47137 for ; Thu, 26 Aug 1999 16:17:11 -0400 (EDT) (envelope-from hostmaster@virtuel.qc.ca) Received: from maximum [207.96.141.5] by virtuel.qc.ca (SMTPD32-4.07) id A060191D0124; Thu, 26 Aug 1999 16:15:28 EDT Message-ID: <003101beefff$f7b229e0$058d60cf@virtuel.qc.ca> From: "Nicolas Cadou" To: "Yury Don" Cc: "pgsql-sql list" References: <199908201918.MAA31413@uno.tksoft.com> <001901beeb72$040ad350$058d60cf@virtuel.qc.ca> <37C0C438.DB5996CA@vpcit.ru> Subject: Re: [SQL] Missing PL/pgSQL library Date: Thu, 26 Aug 1999 16:17:05 -0400 Organization: Internet au Virtuel Inc. MIME-Version: 1.0 Content-Type: text/plain; charset="koi8-r" 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 finally managed to make PL/pgSQL work. FYI, I took the library from this package: postgresql-server-6.5.1-0.4lo.i386.rpm I downloaded it from ftp://ftp.redhat.com/rawhide/i386/RedHat/RPMS Nicolas Cadou ----- Original Message ----- From: Yury Don To: Nicolas Cadou Sent: Sunday, August 22, 1999 23:47 Subject: Re: [SQL] Missing PL/pgSQL library > Hi Nicolas > > I am working with debian and there exists separate package for plpgsql, > and I think the same must be in redhat. So, you need to find package > postgresql-plpgsql-6.5-1.beta1.i386.rpm or something like that. > > -- > Sincerely yours, Yury. > don.web-page.net, ICQ 11831432 > > > Nicolas Cadou wrote: > > > > 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 > > > > > > > > > > > > > > > > > > > > ************ > > > > > > > > > > > > > > > > > > ************ >