"optimizer.h" not found when building FDW for postgreSQL 11

[ifarcher]

When we try to build the db2_fdw for PostgreSQL 11, the make process stops with the error telling that file "optimizer.h" is not found.

I had a look at the files contained in the postgresql-server-11-dev package (for debian) and the named file seems not to be part of this package, in contrast to ostgresql-server-12-dev, where it exists.

So maybe db2_fdw can currently not be built for PostgreSQL 10 and 11 because of missing optimizer.h.

Regards, Ingo

[wolfgangbrandl]

I will check. But comment the headerline out please .

Mit freundlichen Grüßen

Ing. Wolfgang Brandl Email: wolfgang.brandl@chello.at Mobil: +43 660 7132911

From: ifarcher notifications@github.com Reply to: wolfgangbrandl/db2_fdw reply@reply.github.com Date: Monday, 6. July 2020 at 16:14 To: wolfgangbrandl/db2_fdw db2_fdw@noreply.github.com Cc: Subscribed subscribed@noreply.github.com Subject: [wolfgangbrandl/db2_fdw] "optimizer.h" not found when building FDW for postgreSQL 11 (#28)

When we try to build the db2_fdw for PostgreSQL 11, the make process stops with the error telling that file "optimizer.h" is not found.

I had a look at the files contained in the postgresql-server-11-dev package (for debian) and the named file seems not to be part of this package, in contrast to ostgresql-server-12-dev, where it exists.

So maybe db2_fdw can currently not be built for PostgreSQL 10 and 11 because of missing optimizer.h.

Regards, Ingo

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub, or unsubscribe.

[ifarcher]

Thank you for the answer! We already did that, but that lead to another problem: then in the generated .so-file a symbol was missing, but I cannot exactly remember its name, it was something like "table_...". This "follow-up-error" was thrown on "create extension". I did not mention that because when I don't know the precise effect of a change (commenting out a header without any knowledge) any resulting error is not significant, i thought. Regards, Ingo

[wolfgangbrandl]

Please try the attached zip file

Mit freundlichen Grüßen

Ing. Wolfgang Brandl Email: wolfgang.brandl@chello.at Mobil: +43 660 7132911

From: ifarcher notifications@github.com Reply to: wolfgangbrandl/db2_fdw reply@reply.github.com Date: Tuesday, 7. July 2020 at 10:36 To: wolfgangbrandl/db2_fdw db2_fdw@noreply.github.com Cc: Brandl Wolfgang wolfgang.brandl@chello.at, Comment comment@noreply.github.com Subject: Re: [wolfgangbrandl/db2_fdw] "optimizer.h" not found when building FDW for postgreSQL 11 (#28)

Thank you for the answer! We already did that, but that lead to another problem: then in the generated .so-file a symbol was missing, but I cannot exactly remember its name, it was something like "table_...". This "follow-up-error" was thrown on "create extension". I did not mention that because when I don't know the precise effect of a change (commenting out a header without any knowledge) any resulting error is not significant, i thought. Regards, Ingo

— You are receiving this because you commented. Reply to this email directly, view it on GitHub, or unsubscribe.

[ifarcher]

Sorry, I cannot find any attachment … Ingo

Von: Wolfgang Brandl notifications@github.com Gesendet: Dienstag, 7. Juli 2020 11:02 An: wolfgangbrandl/db2_fdw db2_fdw@noreply.github.com Cc: Farcher, Ingo (DCCS) Ingo.Farcher@dccs.at; Author author@noreply.github.com Betreff: Re: [wolfgangbrandl/db2_fdw] "optimizer.h" not found when building FDW for postgreSQL 11 (#28)

Please try the attached zip file

Mit freundlichen Grüßen

Ing. Wolfgang Brandl Email: wolfgang.brandl@chello.atmailto:wolfgang.brandl@chello.at Mobil: +43 660 7132911

From: ifarcher notifications@github.com<mailto:notifications@github.com> Reply to: wolfgangbrandl/db2_fdw reply@reply.github.com<mailto:reply@reply.github.com> Date: Tuesday, 7. July 2020 at 10:36 To: wolfgangbrandl/db2_fdw db2_fdw@noreply.github.com<mailto:db2_fdw@noreply.github.com> Cc: Brandl Wolfgang wolfgang.brandl@chello.at<mailto:wolfgang.brandl@chello.at>, Comment comment@noreply.github.com<mailto:comment@noreply.github.com> Subject: Re: [wolfgangbrandl/db2_fdw] "optimizer.h" not found when building FDW for postgreSQL 11 (#28)

Thank you for the answer! We already did that, but that lead to another problem: then in the generated .so-file a symbol was missing, but I cannot exactly remember its name, it was something like "table_...". This "follow-up-error" was thrown on "create extension". I did not mention that because when I don't know the precise effect of a change (commenting out a header without any knowledge) any resulting error is not significant, i thought. Regards, Ingo

— You are receiving this because you commented. Reply to this email directly, view it on GitHub, or unsubscribe.

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHubhttps://github.com/wolfgangbrandl/db2_fdw/issues/28#issuecomment-654707832, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AQGAFOKDQNXNHMY7D77RLYTR2LQAZANCNFSM4ORUYI5A.

[wolfgangbrandl]

Go to

https://github.com/wolfgangbrandl/db2_fdw

and download the zip file

Mit freundlichen Grüßen

Ing. Wolfgang Brandl Email: wolfgang.brandl@chello.at Mobil: +43 660 7132911

From: ifarcher notifications@github.com Reply to: wolfgangbrandl/db2_fdw reply@reply.github.com Date: Tuesday, 7. July 2020 at 15:14 To: wolfgangbrandl/db2_fdw db2_fdw@noreply.github.com Cc: Brandl Wolfgang wolfgang.brandl@chello.at, Comment comment@noreply.github.com Subject: Re: [wolfgangbrandl/db2_fdw] "optimizer.h" not found when building FDW for postgreSQL 11 (#28)

Sorry, I cannot find any attachment … Ingo

Von: Wolfgang Brandl notifications@github.com Gesendet: Dienstag, 7. Juli 2020 11:02 An: wolfgangbrandl/db2_fdw db2_fdw@noreply.github.com Cc: Farcher, Ingo (DCCS) Ingo.Farcher@dccs.at; Author author@noreply.github.com Betreff: Re: [wolfgangbrandl/db2_fdw] "optimizer.h" not found when building FDW for postgreSQL 11 (#28)

Please try the attached zip file

Mit freundlichen Grüßen

Ing. Wolfgang Brandl Email: wolfgang.brandl@chello.atmailto:wolfgang.brandl@chello.at Mobil: +43 660 7132911

From: ifarcher notifications@github.com<mailto:notifications@github.com> Reply to: wolfgangbrandl/db2_fdw reply@reply.github.com<mailto:reply@reply.github.com> Date: Tuesday, 7. July 2020 at 10:36 To: wolfgangbrandl/db2_fdw db2_fdw@noreply.github.com<mailto:db2_fdw@noreply.github.com> Cc: Brandl Wolfgang wolfgang.brandl@chello.at<mailto:wolfgang.brandl@chello.at>, Comment comment@noreply.github.com<mailto:comment@noreply.github.com> Subject: Re: [wolfgangbrandl/db2_fdw] "optimizer.h" not found when building FDW for postgreSQL 11 (#28)

Thank you for the answer! We already did that, but that lead to another problem: then in the generated .so-file a symbol was missing, but I cannot exactly remember its name, it was something like "table_...". This "follow-up-error" was thrown on "create extension". I did not mention that because when I don't know the precise effect of a change (commenting out a header without any knowledge) any resulting error is not significant, i thought. Regards, Ingo

— You are receiving this because you commented. Reply to this email directly, view it on GitHub, or unsubscribe.

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHubhttps://github.com/wolfgangbrandl/db2_fdw/issues/28#issuecomment-654707832, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AQGAFOKDQNXNHMY7D77RLYTR2LQAZANCNFSM4ORUYI5A.

— You are receiving this because you commented. Reply to this email directly, view it on GitHub, or unsubscribe.

[ifarcher]

I assume, for the ZIP file you mean the file you can download when clicking the green "Code" Icon - I cannot see any other ZIP file.

So I did that, but there is no difference to the previous behavior. We commented out all occurrences of optimizer.h. The we started make => resulting in a lot of warnings, eg. mentioning "table_open", "table_close" etc. Then we invoked make install. Then we created the extension:

Error: could not create extension, symbol "table_open" not found in ___.so.

So I cannot see a difference to previous behavior. Maybe there should be another ZIP file that i cannot see/find?

[wolfgangbrandl]

It seems you have several postgresql installation on the same server. When you compile which pg_setup is executed in the make.

What is the output of “which pg_setup” and is this the executable of postgres 12.3?

Mit freundlichen Grüßen

Ing. Wolfgang Brandl Email: wolfgang.brandl@chello.at Mobil: +43 660 7132911

From: ifarcher notifications@github.com Reply to: wolfgangbrandl/db2_fdw reply@reply.github.com Date: Wednesday, 8. July 2020 at 11:57 To: wolfgangbrandl/db2_fdw db2_fdw@noreply.github.com Cc: Brandl Wolfgang wolfgang.brandl@chello.at, Comment comment@noreply.github.com Subject: Re: [wolfgangbrandl/db2_fdw] "optimizer.h" not found when building FDW for postgreSQL 11 (#28)

I assume, for the ZIP file you mean the file you can download when clicking the green "Code" Icon - I cannot see any other ZIP file.

So I did that, but there is no difference to the previous behavior. We commented out all occurrences of optimizer.h. The we started make => resulting in a lot of warnings, eg. mentioning "table_open", "table_close" etc. Then we invoked make install. Then we created the extension:

Error: could not create extension, symbol "table_open" not found in ___.so.

So I cannot see a difference to previous behavior. Maybe there should be another ZIP file that i cannot see/find?

— You are receiving this because you commented. Reply to this email directly, view it on GitHub, or unsubscribe.

[wolfgangbrandl]

Where in Austria are you located with dccs.at?

Mit freundlichen Grüßen

Ing. Wolfgang Brandl Email: wolfgang.brandl@chello.at Mobil: +43 660 7132911

From: ifarcher notifications@github.com Reply to: wolfgangbrandl/db2_fdw reply@reply.github.com Date: Wednesday, 8. July 2020 at 11:57 To: wolfgangbrandl/db2_fdw db2_fdw@noreply.github.com Cc: Brandl Wolfgang wolfgang.brandl@chello.at, Comment comment@noreply.github.com Subject: Re: [wolfgangbrandl/db2_fdw] "optimizer.h" not found when building FDW for postgreSQL 11 (#28)

I assume, for the ZIP file you mean the file you can download when clicking the green "Code" Icon - I cannot see any other ZIP file.

So I did that, but there is no difference to the previous behavior. We commented out all occurrences of optimizer.h. The we started make => resulting in a lot of warnings, eg. mentioning "table_open", "table_close" etc. Then we invoked make install. Then we created the extension:

Error: could not create extension, symbol "table_open" not found in ___.so.

So I cannot see a difference to previous behavior. Maybe there should be another ZIP file that i cannot see/find?

— You are receiving this because you commented. Reply to this email directly, view it on GitHub, or unsubscribe.

[ifarcher]

Hi, we dont't have concurrent installations - we did all tries on separate ones. (Would you still need the output of "which pg_setup"? And we are located in Graz.

Greetings, Ingo

[wolfgangbrandl]

I unzipped the package. and tested it with postgresql 12.3

No problem just 4 warnings which i have to correct.

What is the output of the following:

gmake clean

gmake -n

and the Output of

psql

ifarcher notifications@github.com hat am 9. Juli 2020 um 07:11 geschrieben:

Hi, we dont't have concurrent installations - we did all tries on separate ones. (Would you still need the output of "which pg_setup"?
And we are located in Graz.

Greetings,
Ingo

—
You are receiving this because you commented.
Reply to this email directly, view it on GitHub https://github.com/wolfgangbrandl/db2_fdw/issues/28#issuecomment-655904570 , or unsubscribe https://github.com/notifications/unsubscribe-auth/ACMUXO2ETBLVWQR4VVXK543R2VGOJANCNFSM4ORUYI5A .

mfg.

Ing. Wolfgang Brandl

Mobil: +43 660 7132911

[ifarcher]

Hi, yes, with PostgreSQL 12 make runs quite fine but "import schema" fails (see my other issue-posting). Assuming that "import schema" could be working for older postgreSQL versions, we tried it with PG 11. But for PostgreSQL 11 make fails because of missing optimizer.h, and when we comment that out, it throws a large number of warnings (more than 30). Trying to create the extension afterwards fails, mentioning missing symbols in the .so file. The missing symbols seem to correspond to the previous warnings.

Below you can find the requested output of make (gmake not installed):

root@db1:/opt/install/db2_fdw-master# make clean
rm -f db2_fdw.so   libdb2_fdw.a  libdb2_fdw.pc
rm -f db2_fdw.o db2_utils.o db2_fdw.bc db2_utils.bc
rm -rf results/ regression.diffs regression.out tmp_check/ tmp_check_iso/ log/ output_iso/

root@ db1:/opt/install/db2_fdw-master# make -n
gcc -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute -Wformat-security -fno-strict-aliasing -fwrapv -fexcess-precision=standard -Wno-format-truncation -Wno-stringop-truncation -g -g -O2 -fstack-protector-strong -Wformat -Werror=format-security -fno-omit-frame-pointer -fPIC -g -fPIC -I/include -I. -I./ -I/usr/include/postgresql/11/server -I/usr/include/postgresql/internal  -Wdate-time -D_FORTIFY_SOURCE=2 -D_GNU_SOURCE -I/usr/include/libxml2  -I/usr/include/mit-krb5  -c -o db2_fdw.o db2_fdw.c
gcc -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute -Wformat-security -fno-strict-aliasing -fwrapv -fexcess-precision=standard -Wno-format-truncation -Wno-stringop-truncation -g -g -O2 -fstack-protector-strong -Wformat -Werror=format-security -fno-omit-frame-pointer -fPIC -g -fPIC -I/include -I. -I./ -I/usr/include/postgresql/11/server -I/usr/include/postgresql/internal  -Wdate-time -D_FORTIFY_SOURCE=2 -D_GNU_SOURCE -I/usr/include/libxml2  -I/usr/include/mit-krb5  -c -o db2_utils.o db2_utils.c
gcc -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute -Wformat-security -fno-strict-aliasing -fwrapv -fexcess-precision=standard -Wno-format-truncation -Wno-stringop-truncation -g -g -O2 -fstack-protector-strong -Wformat -Werror=format-security -fno-omit-frame-pointer -fPIC -shared -o db2_fdw.so db2_fdw.o db2_utils.o -L/usr/lib/x86_64-linux-gnu  -Wl,-z,relro -Wl,-z,now -L/usr/lib/llvm-7/lib  -L/usr/lib/x86_64-linux-gnu/mit-krb5 -Wl,--as-needed  -fPIC -L/lib64 -L/bin  -ldb2ci
/usr/bin/clang-7 -Wno-ignored-attributes -fno-strict-aliasing -fwrapv -O2  -g -fPIC -I/include -I. -I./ -I/usr/include/postgresql/11/server -I/usr/include/postgresql/internal  -Wdate-time -D_FORTIFY_SOURCE=2 -D_GNU_SOURCE -I/usr/include/libxml2  -I/usr/include/mit-krb5 -flto=thin -emit-llvm -c -o db2_fdw.bc db2_fdw.c
/usr/bin/clang-7 -Wno-ignored-attributes -fno-strict-aliasing -fwrapv -O2  -g -fPIC -I/include -I. -I./ -I/usr/include/postgresql/11/server -I/usr/include/postgresql/internal  -Wdate-time -D_FORTIFY_SOURCE=2 -D_GNU_SOURCE -I/usr/include/libxml2  -I/usr/include/mit-krb5 -flto=thin -emit-llvm -c -o db2_utils.bc db2_utils.c

… and the output of psql:

root@db1:/opt/install/db2_fdw-master# psql -U postgres
psql (11.8 (Debian 11.8-1.pgdg100+1))
Type "help" for help.

postgres=#

[devrimgunduz]

Hi,

3.0.1 cannot be built against v11 (optimizer.h does not exist in versions less than 12). You will need to add a check around relevant lines.

[wolfgangbrandl]

korrekted

Devrim Gündüz notifications@github.com hat am 29. Juli 2020 um 13:06 geschrieben:

Hi,

3.0.1 cannot be built against v11 (optimizer.h does not exist in versions less than 12). You will need to add a check around relevant lines.

—
You are receiving this because you commented.
Reply to this email directly, view it on GitHub https://github.com/wolfgangbrandl/db2_fdw/issues/28#issuecomment-665599448 , or unsubscribe https://github.com/notifications/unsubscribe-auth/ACMUXO24GOAMZF5NB7TEZI3R577DDANCNFSM4ORUYI5A .

mfg.

Ing. Wolfgang Brandl

Mobil: +43 660 7132911