From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Andy Lewis <alewis(at)themecca(dot)net> |
Cc: | pgsql-hackers(at)postgreSQL(dot)org |
Subject: | Re: [HACKERS] PLpgSQL Stat Problem |
Date: | 1999-04-29 22:39:28 |
Message-ID: | 18150.925425568@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Michael J Davis | 1999-04-29 23:06:49 | RE: [HACKERS] How do I get the backend server into gdb? |
Previous Message | Tom Lane | 1999-04-29 22:33:46 | Re: [HACKERS] How do I get the backend server into gdb? |