pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedFailing to compile sqlite_fdw
5+ messages / 2 participants
[nested] [flat]
* Failing to compile sqlite_fdw
@ 2018-09-16 09:02 Mariel Cherkassky <mariel.cherkassky@gmail.com>
0 siblings, 1 reply; 5+ messages in thread
From: Mariel Cherkassky @ 2018-09-16 09:02 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
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.
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Failing to compile sqlite_fdw
@ 2018-09-16 09:04 Christoph Berg <myon@debian.org>
parent: Mariel Cherkassky <mariel.cherkassky@gmail.com>
0 siblings, 1 reply; 5+ messages in thread
From: Christoph Berg @ 2018-09-16 09:04 UTC (permalink / raw)
To: Mariel Cherkassky <mariel.cherkassky@gmail.com>; +Cc: pgsql-admin@lists.postgresql.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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Failing to compile sqlite_fdw
@ 2018-09-16 09:09 Mariel Cherkassky <mariel.cherkassky@gmail.com>
parent: Christoph Berg <myon@debian.org>
0 siblings, 1 reply; 5+ messages in thread
From: Mariel Cherkassky @ 2018-09-16 09:09 UTC (permalink / raw)
To: myon@debian.org; +Cc: pgsql-admin@lists.postgresql.org
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
>
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Failing to compile sqlite_fdw
@ 2018-09-16 09:12 Christoph Berg <myon@debian.org>
parent: Mariel Cherkassky <mariel.cherkassky@gmail.com>
0 siblings, 1 reply; 5+ messages in thread
From: Christoph Berg @ 2018-09-16 09:12 UTC (permalink / raw)
To: Mariel Cherkassky <mariel.cherkassky@gmail.com>; +Cc: pgsql-admin@lists.postgresql.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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Failing to compile sqlite_fdw
@ 2018-09-16 09:13 Mariel Cherkassky <mariel.cherkassky@gmail.com>
parent: Christoph Berg <myon@debian.org>
0 siblings, 0 replies; 5+ messages in thread
From: Mariel Cherkassky @ 2018-09-16 09:13 UTC (permalink / raw)
To: myon@debian.org; +Cc: pgsql-admin@lists.postgresql.org
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
>
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2018-09-16 09:13 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2018-09-16 09:02 Failing to compile sqlite_fdw Mariel Cherkassky <mariel.cherkassky@gmail.com>
2018-09-16 09:04 ` Christoph Berg <myon@debian.org>
2018-09-16 09:09 ` Mariel Cherkassky <mariel.cherkassky@gmail.com>
2018-09-16 09:12 ` Christoph Berg <myon@debian.org>
2018-09-16 09:13 ` Mariel Cherkassky <mariel.cherkassky@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox