Re: [GENERAL] PG_MODULE_MAGIC issue with small extension

2016-09-02 Thread Brent Douglas
Thanks a lot Tom, it works as expected now. When reading the docs I must have skipped to the code block without properly reading the sentence above. Brent On Fri, Sep 2, 2016 at 11:19 AM, Tom Lane wrote: > Brent Douglas writes: > > pg_zlib.c:24:1: warning: type specifier missing, defaults to '

Re: [GENERAL] PG_MODULE_MAGIC issue with small extension

2016-09-02 Thread Tom Lane
Brent Douglas writes: > pg_zlib.c:24:1: warning: type specifier missing, defaults to 'int' > [-Wimplicit-int] > PG_MODULE_MAGIC; > ^ > 1 warning generated. Ah, I'd thought you'd just misread the documentation, but looking closer I realize that you're probably not understanding the significance of

Re: [GENERAL] PG_MODULE_MAGIC issue with small extension

2016-09-02 Thread Brent Douglas
Hi Tom, Ok, I think I miss-understood the docs. I have the macro in the extension anyway, so basically the cause it that somewhere I'm picking up non 9.5.3 libs when I'm compiling? I upgraded from 9.4.5 not too long ago but I can't find any traces of it left on my system to be interfering. Brent

Re: [GENERAL] PG_MODULE_MAGIC issue with small extension

2016-09-02 Thread Tom Lane
Brent Douglas writes: > What I have found however is that when I go to load my extensions I get > this error: > test=# create extension pg_zlib; > ERROR: incompatible library "/usr/local/lib/postgresql/pg_zlib.so": > missing magic block > HINT: Extension libraries are required to use the PG_MOD

[GENERAL] PG_MODULE_MAGIC issue with small extension

2016-09-02 Thread Brent Douglas
Hello all, I'm not sure if this is the correct list for extensions, if not please let me know where this should be sent too. I have a mid sized append only table that is read fairly infrequently and contains 2 columns that contain on average about 0.5Kb and 2Kb of xml per row. In an attempt to sa