[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

Re: [GENERAL] PG_MODULE_MAGIC issue with small extension

2016-09-02 Thread Brent Douglas
rfering. Brent On Fri, Sep 2, 2016 at 11:07 AM, Tom Lane wrote: > 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/loca

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, de