| 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: | Whole Thread | Raw Message | 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 ? |