Postgres Pro
Downloads
Home   >   mailing lists

Thread: Installing plpgsql proc language

Installing plpgsql proc language

From
Juan F Diaz
Date:
I've been trying to install the plpgsql proc language but the following
error keeps showing:

[whatever:/wherever] createlang plpgsql dbo
ERROR:  Load of file /Library/PostgreSQL/lib/postgresql/plpgsql.so
failed: no error message available

the plpgsql.so file exists on that location, i dont know what happen....

any help would be greatly appreciated (i run postgre under mac os x
10.2.6 client)

thanks!

Re: Installing plpgsql proc language

From
christoph.dellavalle@goetheanum.ch
Date:
did you check the permissions of plpgsql.so?

chris

>
>I've been trying to install the plpgsql proc language but the
>following
>error keeps showing:
>
>[whatever:/wherever] createlang plpgsql dbo
>ERROR:  Load of file /Library/PostgreSQL/lib/postgresql/plpgsql.so
>failed: no error message available
>
>the plpgsql.so file exists on that location, i dont know what
>happen....
>

Re: Installing plpgsql proc language

From
Juan F Diaz
Date:
Yes i checked them, although i'm not sure how they should be i tried
setting different kinds of permissions (r/w/x)... but still the error
message appears...

JuanF

On Wednesday, August 20, 2003, at 12:30  AM,
christoph.dellavalle@goetheanum.ch wrote:

>
> did you check the permissions of plpgsql.so?
>
> chris
>
>>
>> I've been trying to install the plpgsql proc language but the
>> following
>> error keeps showing:
>>
>> [whatever:/wherever] createlang plpgsql dbo
>> ERROR:  Load of file /Library/PostgreSQL/lib/postgresql/plpgsql.so
>> failed: no error message available
>>
>> the plpgsql.so file exists on that location, i dont know what
>> happen....
>>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to
> majordomo@postgresql.org
>

Re: Installing plpgsql proc language

From
Tom Lane
Date:
Juan F Diaz <j-diaz@publicar.com> writes:
> [whatever:/wherever] createlang plpgsql dbo
> ERROR:  Load of file /Library/PostgreSQL/lib/postgresql/plpgsql.so
> failed: no error message available

> any help would be greatly appreciated (i run postgre under mac os x
> 10.2.6 client)

Sorry about the lack of useful error message :-( --- the original coding
for our dynamic-loader support on OS X didn't bother to handle error
message feedback, and we didn't remember to finish it for awhile.

If you don't mind compiling your own version, get the latest version of
src/backend/port/dynloader/darwin.c from our CVS server (or 7.4beta1).
It should drop into any recent PG release, and then you can find out
what condition is hiding behind the "no error message available".

            regards, tom lane