Can't compile C program as PostgreSQL stored procedure

Question

everyone. I try to make simple example of how to create stored procedures in PostgreSQL written in C language. When compiling "test.c" there's an error "Unknown type Datum". I use Version 1 Calling convention. PostgreSQL 9.1 is installed on my server under Ubuntu 11.10. Please help. By the way does anybody have step-by-step example of creating stored procedures in C language? Thanks

post relevant code, which will save the guess-work for everyone. — P.P
– P.P, Commented May 21, 2012 at 13:55
Based on the "Unknown type" diagnostic, it sounds like you've forgotten to #include a header file from the PostgreSQL implementation. Unfortunately, I don't know what that file would be. — John Bode
– John Bode, Commented May 21, 2012 at 15:52
You should really show the whole compiler error sequence. Copy and paste. — Craig Ringer
– Craig Ringer, Commented May 21, 2012 at 23:43
The problem was I use #include "postgres.h" instead of #include "/usr/include/postgresql/postgres.h". Now I can't compile shared object. code cc -shared -o /usr/include/postgresql/foo.so /usr/include/postgresql/foo.o. cc: error: /usr/include/postgresql/foo.o: No such file or directory cc: fatal error: no input files compilation terminated. Thanks — geaden
– geaden, Commented May 22, 2012 at 8:05

Kuberchaun · Accepted Answer · 2012-05-21 15:00:07Z

2

I wrote up a mind dump while I was doing this awhile back on FreeBSD. Here is the link in case it might help.

Compile C function to stored procedure brain dump

answered May 21, 2012 at 15:00

Kuberchaun

30.5k8 gold badges54 silver badges59 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

geaden Over a year ago

Thank you, very much! I'll try as soon as get my pc

John Conde · Accepted Answer · 2012-10-17 15:31:11Z

1

Search for the postgres server includes path (Debian Wheezy = /usr/include/postgresql/9.1/server/)
Change #include directives inside the PostgreSQL example (foo.c) from #include "" to #include<>
To compile, add the include search path with the directive

-I (gcc -fpic -c foo.c -I/usr/include/postgresql/9.1/server/)
Continue as its said in the Postgres documentation

http://www.postgresql.org/docs/9.1/static/xfunc-c.html

edited Oct 17, 2012 at 15:31

John Conde

220k100 gold badges464 silver badges504 bronze badges

answered Oct 17, 2012 at 15:25

Rafael Gandía

111 bronze badge

Collectives™ on Stack Overflow

Can't compile C program as PostgreSQL stored procedure

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related