Received: from postgresql.org.org (webmail.postgresql.org [216.126.85.28]) by postgresql.org (8.11.3/8.11.4) with SMTP id f7EGeHP79691 for ; Tue, 14 Aug 2001 12:40:17 -0400 (EDT) (envelope-from pgsql-general-owner@postgresql.org) Received: from news.tht.net (news.hub.org [216.126.91.242]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f77IWN617952; Tue, 7 Aug 2001 14:32:23 -0400 (EDT) (envelope-from news@news.tht.net) Received: (from news@localhost) by news.tht.net (8.11.4/8.11.4) id f77IRKc09926; Tue, 7 Aug 2001 14:27:20 -0400 (EDT) (envelope-from news) From: Raymond Chui X-Newsgroups: comp.databases.postgresql.general,comp.databases.postgresql.sql Subject: Where is pgplsql.so located in 7.1.2? Date: Tue, 07 Aug 2001 14:00:48 -0400 Organization: Department of Commerce/NOAA/NWS Lines: 29 Message-ID: <3B702CD0.DC904453@noaa.gov> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Mailer: Mozilla 4.75 [en] (Win98; U) X-Accept-Language: en To: pgsql-general@postgresql.org.pgsql-sql@postgresql.org X-Archive-Number: 200108/342 X-Sequence-Number: 13595 When I do createlang -U postgres -d mydbname pgplsql mydbname I got can't find /usr/share/pgsql/plpgsql.so error message. But there is no plpgsql.so file in /usr/share/pgsql directory! I just installed RPM binary 7.1.2 for Redhat 6.2 In 7.0 the pgplsql.so file is located in /usr/lib/pgsql/ So I do createlang -U postgres -d mydbname --pglib=/usr/lib/pgsql pgplsql mydbname Then I got A function named plpgsql_call_handler already exists. Installation abort. But createlang -l mydbname shows there is nothing there. Shall I do drop function plpgsql_call_handler; ? Or where I can find plpgsql.so file for 7.1.2 in /usr/share/pgsql/ ? Please don't tell me I need to compile PostgreSQL by myself order to get all *.so files. --Raymond