Thread: 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