http://forums.enterprisedb.com/posts/list/3.page JForum - http://www.jforum.net
If I set my -I flags to that directory and it server subdirectory I am able to compile a simple c file into a .so. However when I try to 'create or replace function' using that .so I get an error that it is missing a magic block. I tried to include:

#ifdef PG_MODULE_MAGIC
PG_MODULE_MAGIC;
#endif

in the .c file, but it didn't help. grep of that directory finds no files that contain PG_MODULE_MAGIC.

I did find /usr/postgres/8.2/include and /usr/postgres/8.3/include directories though, and tried compiling against them. Using 8.2, when I create the function I get an "incompatible library" magic block mismatch error. But if I compile against 8.3 the error states "Server: 8.2, Library: 8.3".

I am really at a loss how to resolve this problem. Can anyone recommend a solution?

Thanks,
Dave D]]> http://forums.enterprisedb.com/posts/preList/2427/9147.page http://forums.enterprisedb.com/posts/preList/2427/9147.page GMT
Please share the code. Let me see if I can make it workable for PG8.4.]]> http://forums.enterprisedb.com/posts/preList/2427/9170.page http://forums.enterprisedb.com/posts/preList/2427/9170.page GMT
Thanks,
Dave]]> http://forums.enterprisedb.com/posts/preList/2427/9178.page http://forums.enterprisedb.com/posts/preList/2427/9178.page GMT