PLpgSQL Stat Problem

I posted the following message in [GENERAL] and still haven't been able to
resolve the problem.

The file permissions are set to postgres and postgres is authorized to
access /usr/local/pgsql/lib.

What I am trying to do is insert a row into a DB but, I want to be able to
check each row for a specified column prior to insert to see if there is a
duplicate column.
If there is I want to be able to abort or simply skip that insert. If
there are any easier ways to do this please let me know.

I'm running Postgres 6.4.2 on Linux.

Any ideas would be greatly appreciated.

Please email any resonses to the above email address as I don't belong to
[HACKERS].

Thanks in advance.

Andy



> 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
> ----------------------------------------------------------
> 
> The file plpgsql.so does exist in /usr/local/pgsql/lib.
> Any ideas?