I've compiled pgdriver version 2.0.1 with the PGLIB=/usr/local/pgsql2/lib and PGINC=/usr/local/pgsql2/include. I also compiled postgres with --prefix=/usr/local/pgsql2. I have a run script to startup aolserver that sets the environment var: LD_LIBRARY_PATH=/usr/local/pgsql2/lib AOLserver starts up fine, connects to the database and even does some queries, but it then seems to need some plpgsql help, and it tries to load: /usr/local/pgsql/lib/plpgsql.so but fails with 'undefined symbol: SPI_cursor_open.
AOLserver complains: ns_PgExec: result status: 7 message: ERROR: Load of file /usr/local/pgsql/lib/plpgsql.so failed...
Any ideas on what I am doing wrong?
Also postgres was compiled on another machine. For some reason, 7.1.3 doesn't compile on RH8.0
--Tom Jackson
-- AOLserver - http://www.aolserver.com/ To Remove yourself from this list: http://www.aolserver.com/listserv.html List information and options: http://listserv.aol.com/