Re: [HACKERS] PLpgSQL Stat Problem

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(at)themecca(dot)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
>