From: | "Michael R(dot) Fahey" <mfahey(at)qilinlaw(dot)com> |
---|---|
To: | <pgsql-novice(at)postgresql(dot)org> |
Subject: | Can't createlang plpgsql |
Date: | 2001-10-14 07:08:30 |
Message-ID: | 412DD2FBFC58D543B7FE12ABF0D305F63AAF71@mail.qilinlaw.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Hello
I can't get pl/pgsql to install using creatlang. I've listed what I did
and the messages I received.
I'm running 7.1.3 configured as follows:
./configure --enable-multibyte=UNICODE --enable-unicode-conversion
--with-perl
The distro is Redhat 7.1.
Thanks.
Michael Fahey
$ createlang -l template1
Procedural languages
Name | Trusted? | Compiler
------+----------+----------
(0 rows)
$createlang plpgsql template1
createlang: missing required argument PGLIB directory
(This is the directory where the interpreter for the procedural
language is stored. Traditionally, these are installed in whatever
'lib' directory was specified at configure time.)
$export PGLIB=/usr/local/pgsql/lib
echo $PGLIB
/usr/local/pgsql/lib
$ls /usr/local/pgsql/lib
libecpg.a
libecpg.so
libecpg.so.3
libecpg.so.3.2.0
libpgeasy.a
libpgeasy.so
libpgeasy.so.2
libpgeasy.so.2.1
libpq.a
libpq.so
libpq.so.2
libpq.so.2.1
plpgsql.so
#the next few messages are really confusing me.
$createlang plpgsql template1
createlang: A function named 'plpgsql_call_handler' already exists.
Installation aborted.
$droplang -d template1 plpgsql
droplang: 'plpgsql' is not installed in database template1
$createlang plpgsql template1
createlang: A function named 'plpgsql_call_handler' already exists.
Installation aborted.
createlang -l template1
Procedural languages
Name | Trusted? | Compiler
------+----------+----------
(0 rows)
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2001-10-14 16:20:38 | Re: Can't createlang plpgsql |
Previous Message | Vijay Deval | 2001-10-13 11:57:40 | Re: installation problem -please help |