Folow up : ERROR: Could not find function - Mailing list pgsql-novice

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