Received: from virtuel.qc.ca (virtuel.qc.ca [207.96.141.2]) by hub.org (8.9.3/8.9.3) with SMTP id NAA98542 for ; Fri, 20 Aug 1999 13:00:00 -0400 (EDT) (envelope-from hostmaster@virtuel.qc.ca) Received: from maximum [207.96.141.5] by virtuel.qc.ca (SMTPD32-4.07) id A93111850124; Fri, 20 Aug 1999 12:58:25 EDT Message-ID: <002f01beeb2d$8febe610$058d60cf@virtuel.qc.ca> From: "Nicolas Cadou" To: "pgsql-sql list" Subject: Missing PL/pgSQL library Date: Fri, 20 Aug 1999 13:00:52 -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 [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