X-Original-To: pgsql-sql@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id A9B0D4758F1 for ; Tue, 15 Apr 2003 13:39:15 -0400 (EDT) Received: from rtlocal.trade-india.com (mail-relay.trade-india.com [203.196.129.235]) by postgresql.org (Postfix) with SMTP id 620D3474E44 for ; Tue, 15 Apr 2003 13:39:01 -0400 (EDT) Received: (qmail 2373 invoked from network); 15 Apr 2003 17:41:25 -0000 Received: from ns1.trade-india.com (HELO www.trade-india.com) (66.234.10.14) by infocom-236-129-del.trade-india.com with SMTP; 15 Apr 2003 17:41:25 -0000 Received: (qmail 6913 invoked by uid 99); 15 Apr 2003 17:37:58 -0000 Received: from 219.65.253.230 (SquirrelMail authenticated user mallah) by mail.trade-india.com with HTTP; Tue, 15 Apr 2003 23:07:58 +0530 (IST) Message-ID: <1305.219.65.253.230.1050428278.squirrel@mail.trade-india.com> Date: Tue, 15 Apr 2003 23:07:58 +0530 (IST) Subject: Re: plpgsql From: To: In-Reply-To: <002601c30375$0ad87240$7739e2c2@zodiacfhynm2is> References: <002601c30375$0ad87240$7739e2c2@zodiacfhynm2is> X-Priority: 3 Importance: Normal X-MSMail-Priority: Normal Cc: X-Mailer: SquirrelMail (version 1.2.6) MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable X-Spam-Status: No, hits=-24.1 required=5.0 tests=BAYES_10,IN_REP_TO,MISSING_MIMEOLE,MISSING_OUTLOOK_NAME, NO_REAL_NAME,QUOTED_EMAIL_TEXT,REFERENCES,REPLY_WITH_QUOTES autolearn=ham version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200304/235 X-Sequence-Number: 12936 Have you tried createlang command? $ createlang -Uusername plpgsql dbname > Hello everybody! > I have a problem with using language "plpgsql". > > When i try to create plpgsql_call_handler() i receive error message: "Loa= d of file > /usr/local/psql/lib/plpgsql.so failed: > /usr/local/psql/lib/plpgsql.so: undefined symbol: getTypeInputInfo" > > Listing of function is: > CREATE FUNCTION plpgsql_call_handler() RETURNS OPAQUE > AS '/usr/local/psql/lib/plpgsql.so' > LANGUAGE 'C'; > > I'm using PostgreSQL 7.2 installed from rpm's. File plpgsql.so exists and= is placed in correct > folder. > > What this error means and what should i do? > > Thanks for any help. > > P.S. OS is AspLinux... ----------------------------------------- Get your free web based email at trade-india.com. "India's Leading B2B eMarketplace.!" http://www.trade-india.com/