Failing to compile sqlite_fdw

From: Mariel Cherkassky <mariel(dot)cherkassky(at)gmail(dot)com>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Failing to compile sqlite_fdw
Date: 2018-09-16 09:02:08
Message-ID: CA+t6e1=6O2cqEPw4KQYMa+MYUFamL7GxS59NX-zGL2fa6QZJNw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Christoph Berg 2018-09-16 09:04:06 Re: Failing to compile sqlite_fdw
Previous Message Imre Samu 2018-09-15 11:21:16 Re: Difference between C and en_US.UTF-8 Collate & CType in Postgres 10.x