Failing to compile sqlite_fdw

Поиск
Список
Период
Сортировка
От Mariel Cherkassky
Тема Failing to compile sqlite_fdw
Дата
Msg-id CA+t6e1=6O2cqEPw4KQYMa+MYUFamL7GxS59NX-zGL2fa6QZJNw@mail.gmail.com
обсуждение исходный текст
Ответы Re: Failing to compile sqlite_fdw
Список pgsql-admin
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.

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

Предыдущее
От: Imre Samu
Дата:
Сообщение: Re: Difference between C and en_US.UTF-8 Collate & CType in Postgres 10.x
Следующее
От: Christoph Berg
Дата:
Сообщение: Re: Failing to compile sqlite_fdw