Re: [HACKERS] plpgsql problem..

This might sound like an ignorant question but how does one dump the
function catalog?

----- Original Message -----
From: Sevo Stille <sevo@ip23.net>
To: Mitch Vincent <mitch@venux.net>
Cc: Postgres Hackers List <hackers@postgreSQL.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
>