From: Raymond Chui <raymond.chui@noaa.gov>
To: pgsql-general@postgresql.org.pgsql-sql
Subject: Where is pgplsql.so located in 7.1.2?
Date: Tue, 07 Aug 2001 14:00:48 -0400
Message-ID: <3B702CD0.DC904453@noaa.gov> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: raymond.chui@noaa.gov, pgsql-general@postgresql.org.pgsql-sql
Subject: Re: Where is pgplsql.so located in 7.1.2?
In-Reply-To: <3B702CD0.DC904453@noaa.gov>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox