I need to extend postgreSQL to support some specific function I will 
code in C (ideally C++ if it can work!).  I'm trying to run some simple 
test and it doesn't seem to work.  Here is the C code:

#include "postgres.h"
#include <string.h>

add_one(int arg)
  return arg + 1;

Which is compiled with:
gcc -fpic -c -I/[ThePath]/postgresql-7.3.2/include/server/ pgsql_bio.c
gcc -shared -o pgsql_bio.so pgsql_bio.o

It compiles fine.

And then in postgreSQL as user postgres in database template1:
CREATE FUNCTION add_one(int4) RETURNS int4
     AS '/[PathToTheObject]/pgsql_bio.so' LANGUAGE C
     WITH (isStrict);

Then I get:
ERROR:  Can't find function add_one in file /[PathToTheObject]/pgsql_bio.so

I'm using PostgreSQL 7.3.2 on Redhat 7.2 (linux 2.4.7-10) and compiling 
with gcc 2.95.3.

Following some suggestions I found on usenet, I ran 'nm' on the library 
and I got the expected entry for my function:
00000700 T add_one

Anyone has an idea about what I am doing wrong?  Any suggestion will be 


Sebastien Lemieux
Bioinformatics, post-doc

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Reply via email to