Error with Postgres PL/pgsql

["Eric G . Miller" <egm2@jps.net>]

  Anyone using Postgres' PL language with success? Postgres apparently
  is having problems finding the pgplsql.so library.  I can't figure out
  why. Is a bug report in order? I made sure the language was
  "installed" for the database and checked the library path setting.

  Here's the output of postgres.log from a short session:

%BEGIN LOG%
/usr/lib/postgresql/bin/postmaster child[6494]: starting with
(/usr/lib/postgres
ql/bin/postgres -d3 -E -v131072 -p address_book )
FindExec: found "/usr/lib/postgresql/bin/postgres" using argv[0]
debug info:
        User         = felix
        RemoteHost   = localhost
        RemotePort   = 0
        DatabaseName = address_book
        Verbose      = 3
        Noversion    = f
        timings      = f
        dates        = Normal
        bufsize      = 64
        sortmem      = 512
        query echo   = t
InitPostgres
StartTransactionCommand
query: select version();
ProcessQuery
CommitTransactionCommand
StartTransactionCommand
query: insert into person_address values (1,1);
ProcessQuery
ERROR:  stat failed on file '@expanded_libdir@/plpgsql@DLSUFFIX@': No
such file or directory
AbortCurrentTransaction
proc_exit(0) [#0]
shmem_exit(0) [#0]
exit(0)
/usr/lib/postgresql/bin/postmaster: reaping dead processes...
/usr/lib/postgresql/bin/postmaster: CleanupProc: pid 6494 exited with
status 0
%END LOG%

I haven't been able to track down where/how it calls 'stat'. My guess is
that the variables @expanded_libdir@ and @DLSUFFIX@ aren't getting
expanded, or weren't expanded in a MAKEFILE. But, I don't know.
-- 
+---+----+-----+---+----+-----+---+----+-----+
|   YOUR AD HERE............1.900.FOO.BARZ   |
+-----+---+----+-----+---+----+-----+---+----+