OS/X and PL/PGSQL
I am having a very very odd time with PostgreSQL 7.3.2 and PL/PGSQL. I
am pretty sure that I have a working install of 7.3.2 and PL/PGSQL.
However, I don't now, for reasons which are not clear. I can create a
new database, and try to add PL/PGSQL to it, and the results are as
follows:
[Robin:~] pramsey% createdb pltest
CREATE DATABASE
[Robin:~] pramsey% createlang plpgsql pltest
ERROR: Load of file /usr/local/pgsql/lib/plpgsql.so failed: no error
message available
createlang: language installation failed
The library file *does* exist, and the permissions are all set so that
the library is readable. Any ideas on this one?
Paul Ramsey
Refractions Research
Email: pramsey@refractions.net
Phone: (250) 885-0632
Paul Ramsey <pramsey@refractions.net> writes:
[Robin:~] pramsey% createlang plpgsql pltest
ERROR: Load of file /usr/local/pgsql/lib/plpgsql.so failed: no error
message available
Not sure if this is true on OS/X, but on many Unixen, the dynamic loader
will write failure messages on stderr that are much more useful than the
narrow-band error indicator returned to the calling code. Make sure
your setup is sending postmaster stderr to a file, not /dev/null, and
then look in the file to see if this produces any interesting output.
regards, tom lane
Tom Lane writes:
Not sure if this is true on OS/X, but on many Unixen, the dynamic loader
will write failure messages on stderr that are much more useful than the
narrow-band error indicator returned to the calling code. Make sure
your setup is sending postmaster stderr to a file, not /dev/null, and
then look in the file to see if this produces any interesting output.
Or maybe it's because of this?
char *
pg_dlerror(void)
{
return "no error message available";
}
;-)
--
Peter Eisentraut peter_e@gmx.net
Peter Eisentraut <peter_e@gmx.net> writes:
Or maybe it's because of this?
char *
pg_dlerror(void)
{
return "no error message available";
}
Hmm, that's sure not helping any :-(. But I don't think it invalidates
my suggestion to look at stderr.
Paul, did you find what was the significant difference between your
boot-time and hand-started postmaster environments?
regards, tom lane
No, unfortunately it is one of those reboot, reinstall, kinds of
things. I recompiled and reinstalled PgSQL. Stopped it. Ran it from
command prompt. It worked. That was when I emailed you. But then I
rebooted, so it started via the system scripts. Still worked. I wish I
knew what it was. I assume at some point it'll stop working again :)
Thanks guys!
Paul
On Thursday, April 10, 2003, at 07:48 PM, Tom Lane wrote:
Peter Eisentraut <peter_e@gmx.net> writes:
Or maybe it's because of this?
char *
pg_dlerror(void)
{
return "no error message available";
}Hmm, that's sure not helping any :-(. But I don't think it invalidates
my suggestion to look at stderr.Paul, did you find what was the significant difference between your
boot-time and hand-started postmaster environments?regards, tom lane
Paul Ramsey
Refractions Research
Email: pramsey@refractions.net
Phone: (250) 885-0632