pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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




Message-ID: <3B702CD0.DC904453@noaa.gov>
Permalink:  ../3B702CD0.DC904453@noaa.gov/
Also on:    postgresql.org/message-id/3B702CD0.DC904453@noaa.gov

 · 

reply

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