Thread: Failing to compile sqlite_fdw
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.
Re: Mariel Cherkassky 2018-09-16 <CA+t6e1=6O2cqEPw4KQYMa+MYUFamL7GxS59NX-zGL2fa6QZJNw@mail.gmail.com> > In file included from connection.c:15: > sqlite_fdw.h:16:21: error: sqlite3.h: No such file or directory > 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) You need the sqlite3 header files, from a package named like sqlite3-devel, or similar. Christoph
Hi,
thanks I installed the sqlite-devel package. Now I'm getting warnings :
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
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 option.o option.c
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 deparse.o deparse.c
deparse.c: In function ‘deparseFromExpr’:
deparse.c:889: warning: unused variable ‘foreignrel’
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 sqlite_query.o sqlite_query.c
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 sqlite_fdw.o sqlite_fdw.c
sqlite_fdw.c:1817: warning: ‘sqliteGetForeignUpperPaths’ defined but not used
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 -shared -o sqlite_fdw.so connection.o option.o deparse.o sqlite_query.o sqlite_fdw.o -L/usr/pgsql-9.6/lib -Wl,--as-needed -L/usr/lib64 -Wl,--as-needed -Wl,-rpath,'/usr/pgsql-9.6/lib',--enable-new-dtags -lsqlite3
Can I still continue and install the extension ? Should I ignore the warnings ?
בתאריך יום א׳, 16 בספט׳ 2018 ב-12:04 מאת Christoph Berg <myon@debian.org>:
Re: Mariel Cherkassky 2018-09-16 <CA+t6e1=6O2cqEPw4KQYMa+MYUFamL7GxS59NX-zGL2fa6QZJNw@mail.gmail.com>
> In file included from connection.c:15:
> sqlite_fdw.h:16:21: error: sqlite3.h: No such file or directory
> 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)
You need the sqlite3 header files, from a package named like
sqlite3-devel, or similar.
Christoph
Re: Mariel Cherkassky 2018-09-16 <CA+t6e1=G4PmcGp1m5APH5ubn_-nB16HsBp7pG7eY7RK=b9mfAQ@mail.gmail.com> > Can I still continue and install the extension ? Should I ignore the > warnings ? The warnings should be harmless, yes. Christoph
Thanks Man !
בתאריך יום א׳, 16 בספט׳ 2018 ב-12:12 מאת Christoph Berg <myon@debian.org>:
Re: Mariel Cherkassky 2018-09-16 <CA+t6e1=G4PmcGp1m5APH5ubn_-nB16HsBp7pG7eY7RK=b9mfAQ@mail.gmail.com>
> Can I still continue and install the extension ? Should I ignore the
> warnings ?
The warnings should be harmless, yes.
Christoph