Forgot to mention, I am on 9.2.1. "SELECT version();" reports: PostgreSQL 9.2.1 on x86_64-unknown-linux-gnu, compiled by gcc (Debian 4.4.5-8) 4.4.5, 64-bit
-Dave On Tue, Jan 8, 2013 at 12:30 PM, David Fuhry <dfu...@gmail.com> wrote: > Hi, I'm trying to add a C-Language function but getting the following > error: > > $ psql -f test_cfunc.sql > psql:test_cfunc.sql:3: ERROR: incompatible library > "/usr/local/pgsql/lib/test_cfunc.so": missing magic block > HINT: Extension libraries are required to use the PG_MODULE_MAGIC macro. > > I am calling PG_MODULE_MAGIC in my c file. Minimal Makefile, .c, and .sql > files are attached. In the Makefile, if I change "MODULE_big" to "MODULES", > it works. However, I want to use "MODULE_big" because I need to later link > to a shared library using SHLIB_LINK, and "MODULES" doesn't support > SHLIB_LINK as per > http://archives.postgresql.org/pgsql-hackers/2012-03/msg00537.php > > Any suggestions on how I can get PG_MODULE_MAGIC to work with "MODULE_big" > (or link a shared library when using "MODULES")? > > Thanks, > > Dave > > >
