Thanks Adrian, though still no luck for me. The compiling was working OK already, the install still goes to 9.2.
Any further help appreciated! Thanks.
Where did you get the table_log extension
I no longer remember (it's been a few years), but my tgz file was the same as what's on pgfoundry
I usually do something like(using existing Makefile):
PATH=/usr/local/pgsql96/bin/:$PATH make USE_PGXS=1 clean all
...
Though in both cases the extension did not actually compile due to errors.
That worked fine for me. (Somewhere along the way I added these two lines to table_log.c:
+#include <utils/rel.h> |
+#include <utils/timestamp.h>
)
But the install still goes to 9.2:
PATH=/usr/local/pgsql96/bin/:$PATH make USE_PGXS=1 install |
/bin/mkdir -p '/usr/pgsql-9.2/share/contrib'
/bin/mkdir -p '/usr/pgsql-9.2/lib'
/bin/mkdir -p '/usr/pgsql-9.2/doc/contrib'
/usr/bin/install -c -m 644 table_log.sql '/usr/pgsql-9.2/share/contrib/'
/usr/bin/install -c -m 755 table_log.so '/usr/pgsql-9.2/lib/'
/usr/bin/install -c -m 644 .//README.table_log '/usr/pgsql-9.2/doc/contrib/'
Ken
--
AGENCY Software
A Free Software data system
By and for non-profits
(253) 245-3801
learn more about AGENCY or
follow the discussion.