Re: Failing to compile sqlite_fdw

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(at)debian(dot)org‬‏>:‬

> Re: Mariel Cherkassky 2018-09-16 <CA+t6e1=
> 6O2cqEPw4KQYMa+MYUFamL7GxS59NX-zGL2fa6QZJNw(at)mail(dot)gmail(dot)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
>