From: | "Nigel Bishop" <Nigel(dot)Bishop(at)ioko(dot)com> |
---|---|
To: | "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: Installing plpgsql fails |
Date: | 2003-10-09 09:53:41 |
Message-ID: | 8D206F73E2BE3E419EE87066E31F54EEEB90@intyoad01.uk.ioko365.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Tom,
I tried what Andreas Schmitz suggested (setting PGLIB=/opt/postgres/product/7.3.3/lib in the createlang script), it didn't return an error but there again it didn't return the CREATELANG message either. Though if I then run the "createland lang db" again it says that the language is installed. Selecting from pg_language does not show the plpgsql language.
Running pg_config --pkglibdir returns - /opt/postgres/product/7.3.3/lib
When postgres was installed on this machine back in July the configure script was ran with:
./configure --prefix=/opt/postgres/product/7.3.3
Could this make a difference
I was trying to run the dbsize.sql script which fails (ERROR: stat failed on file '$libdir/plpgsql': No such file or
directory) because the language isn't installed hence why I'm trying to install the lanaguage.
Regards
Nigel Bishop
-----Original Message-----
From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
Sent: 08 October 2003 23:14
To: Nigel Bishop
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: [ADMIN] Installing plpgsql fails
"Nigel Bishop" <Nigel(dot)Bishop(at)ioko(dot)com> writes:
> ERROR: stat failed on file '$libdir/plpgsql': No such file or
> directory
> createlang: language installation failed
> pg_config --libdir - returns:
I think the pg_config setting you need to look at is --pkglibdir.
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | shyamperi | 2003-10-09 12:16:16 | Serious Problem with the windows and postgres configuration |
Previous Message | 2003-10-08 23:10:01 | Re: I don't want more mails |