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