Hi,
I'm trying to install the sqlite_fdw extension (from here - https://github.com/pgspider/sqlite_fdw) on postgresql v 9.6.9.
When I tried to compile it with make I got the next error :
sqlite_fdw-master]# make
Makefile:46: ../../src/Makefile.global: No such file or directory
Makefile:47: /contrib/contrib-global.mk: No such file or directory
make: *** No rule to make target `/contrib/contrib-global.mk'. Stop.
then I searched the error and I found the next solution :
sqlite_fdw-master]#make USE_PGXS=1
gcc -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute -Wformat-security -fno-strict-aliasing -fwrapv -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector --param=ssp-buffer-size=4 -m64 -mtune=generic -fPIC -I. -I./ -I/usr/pgsql-9.6/include/server -I/usr/pgsql-9.6/include/internal -D_GNU_SOURCE -I/usr/include/libxml2 -I/usr/include -c -o connection.o connection.c
In file included from connection.c:15:
sqlite_fdw.h:16:21: error: sqlite3.h: No such file or directory
In file included from connection.c:15:
sqlite_fdw.h:59: error: expected specifier-qualifier-list before ‘sqlite3’
In file included from connection.c:15:
sqlite_fdw.h:165: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’ before ‘*’ token
sqlite_fdw.h:166: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’ before ‘*’ token
sqlite_fdw.h:171: error: expected ‘)’ before ‘*’ token
sqlite_fdw.h:172: error: expected declaration specifiers or ‘...’ before ‘sqlite3_stmt’
sqlite_fdw.h:172: error: expected declaration specifiers or ‘...’ before ‘sqlite3’
sqlite_fdw.h:174: error: expected declaration specifiers or ‘...’ before ‘sqlite3_stmt’
sqlite_fdw.h:176: error: expected declaration specifiers or ‘...’ before ‘sqlite3_stmt’
connection.c:39: error: expected specifier-qualifier-list before ‘sqlite3’
connection.c:57: error: expected ‘)’ before ‘*’ token
.....
...
...
It seems that the compilation of the files failed. Do I need to use some different gcc ? my gcc version :
gcc version 4.4.7 20120313 (Red Hat 4.4.7-23) (GCC)
Any idea ?
Thanks.
