Re: pgxs "missing magic block ... PG_MODULE_MAGIC" with "MODULE_big"

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 <dfuhry(at)gmail(dot)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
>
>
>