Re: Failing to compile sqlite_fdw

Поиск
Список
Период
Сортировка
От Mariel Cherkassky
Тема Re: Failing to compile sqlite_fdw
Дата
Msg-id CA+t6e1=G4PmcGp1m5APH5ubn_-nB16HsBp7pG7eY7RK=b9mfAQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Failing to compile sqlite_fdw  (Christoph Berg <myon@debian.org>)
Ответы Re: Failing to compile sqlite_fdw  (Christoph Berg <myon@debian.org>)
Список pgsql-admin
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

В списке pgsql-admin по дате отправления:

Предыдущее
От: Christoph Berg
Дата:
Сообщение: Re: Failing to compile sqlite_fdw
Следующее
От: Christoph Berg
Дата:
Сообщение: Re: Failing to compile sqlite_fdw