Error with Postgres PL/pgsql
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 |
+-----+---+----+-----+---+----+-----+---+----+
Reply to: