Folow up : ERROR: Could not find function

Dear all,

After some advise I tried a couple of improvements
to my aprouch. With the next result:

I removed the "iostream.h" and "string.h" from my #include directives
And started compiling with gcc instead off g++ But still:

> ERROR: Could not find function 'runTest'  in file
'/usr/local/lib/funcTest.so'

I would be very thankfull if we can 'catch' my stupid error.

Here my steps ->

/* Next steps to compile_______________________________________________

Witch server engine?

$ pg_config --version
PostgreSQL 7.4.7

Determine configuration path;
--includedir -->> Print the location of C header files

$ pg_config --includedir-server
usr/include/postgresql/server

This is the compiler we use on a debian sarge installation;
$ gcc --version
gcc (GCC) 3.3.5 (Debian 1:3.3.5-13)

The we compile it;
gcc -c -fPIC -isystem /usr/include/postgresql/server funcTest.cpp
gcc -shared -o funcTest.so funcTest.o

After the file .so is copied to the path /usr/local/lib
We check this entry in /etc/ld.so.conf
The file looks like: /usr/X11R6/lib
/usr/local/lib

Then we use ldconfig

#### NOTE> so file in /usr/local/lib is NOT mentioned by ldconfig --verbose

Then I use kpogre (1.3.5. on KDE 3.3.2) to parse the next SQL:
( and using libpqxx 2.3.4 )
CREATE FUNCTION test() RETURNS integer
AS '/usr/local/lib/funcTest.so', 'runTest'
LANGUAGE C STRICT;
*/

#include "postgres.h"
#include "fmgr.h"
// postgres syntax version 1.
PG_FUNCTION_INFO_V1(runTest);
Datum runTest(PG_FUNCTION_ARGS) {
// do something
int a;
a = 0;
PG_RETURN_INT32(a);
}

TANXS!!!!!!!!!! ;-)

With regards, Willem Greveling