Solved! Thanks.
I know this is dumb but, I ran mklang.sql on a test DB and in that file it
references: ${exec_prefix}
Without thinking to remove the DB and start from scratch.
Anyway thanks to all.
Andy
On Thu, 29 Apr 1999, Tom Lane wrote:
> Andy Lewis <alewis@themecca.net> writes:
> >> I got the following error after trying to copy the example at:
> >> http://www.postgresql.org/mhonarc/pgsql-sql/1999-04/msg00076.html
> >>
> >> test=> select a(pin,first_name) from ibs_subscriber ;
> >> ERROR: stat failed on file ${exec_prefix}/lib/plpgsql.so
>
> Looks like the system is trying to use the literal filename
> "${exec_prefix}/lib/plpgsql.so", which of course is not right.
>
> I'm guessing that when you copied the CREATE FUNCTION out of the
> example, you just cut and pasted without doing the shell variable
> expansion that was supposed to happen to replace ${exec_prefix}
> with /usr/local/pgsql ...
>
> regards, tom lane
>