Re: [HACKERS] plpgsql problem..

Just an additional comment.

I re-configured and re-installed Postgre and there is no change...

I'm baffled....

----- Original Message -----
From: Sevo Stille <sevo(at)ip23(dot)net>
To: Mitch Vincent <mitch(at)venux(dot)net>
Cc: Postgres Hackers List <hackers(at)postgreSQL(dot)org>
Sent: Tuesday, February 01, 2000 10:28 AM
Subject: Re: [HACKERS] plpgsql problem..

> Mitch Vincent wrote:
>
> > ERROR: stat failed on file '${exec_prefix}/lib/plpgsql.so': No such
file or
> > directory
>
> > I can't find any reference to the $exec_prefix variable on either
machine,
> > yet it works on the development server and not on the live server.
>
> PostgreSQL does not expand environment variables when looking for
> function code. Presumably your installer is broken and did not
> substitute the variable at install time on the affected system. You
> might dump your function catalog on both systems to compare - if the
> function path on the sane system contains a variable as well, there is
> some strange magic going on there.
>
> Sevo
>