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
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 |
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 ? |