Where is pgplsql.so located in 7.1.2?

From: Raymond Chui <raymond(dot)chui(at)noaa(dot)gov>
To: pgsql-general(at)postgresql(dot)org(dot)pgsql-sql(at)postgresql(dot)org
Subject: Where is pgplsql.so located in 7.1.2?
Date: 2001-08-07 18:00:48
Message-ID: 3B702CD0.DC904453@noaa.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-sql

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

Browse pgsql-general by date

  From Date Subject
Next Message Brent R. Matzelle 2001-08-07 18:03:35 Re: Admin tool
Previous Message Eric, Audet 2001-08-07 17:19:20 Admin tool

Browse pgsql-sql by date

  From Date Subject
Next Message Joe Conway 2001-08-07 18:11:10 Re: Re: Fuzzy matching
Previous Message Josh Berkus 2001-08-07 17:52:38 Re: Are circular REFERENCES possible ?