Error in Execution of Make command on Postgre Sql V 14

[dpanjwani06]

Hi,

When trying to run the make command , I am getting the below error

-bash-4.2$ make install gcc -std=gnu99 -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Werror=vla -Wendif-labels -Wmissing-format-attribute -Wformat-security -fno-strict-aliasing -fwrapv -fexcess-precision=standard -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector-strong --param=ssp-buffer-size=4 -grecord-gcc-switches -m64 -mtune=generic -fPIC -g -fPIC -I/opt/KX/IBM/db2/insthome1/sqllib/include -I. -I./ -I/usr/pgsql-14/include/server -I/usr/pgsql-14/include/internal -D_GNU_SOURCE -I/usr/include/libxml2 -I/usr/include -c -o db2_fdw.o db2_fdw.c db2_fdw.c: In function db2_fdw_handler: db2_fdw.c:366:39: warning: assignment from incompatible pointer type [enabled by default] fdwroutine->AddForeignUpdateTargets = db2AddForeignUpdateTargets; ^ db2_fdw.c: In function "db2BeginForeignModify": db2_fdw.c:1628:26: error: "ModifyTableState" has no member named "mt_plans" Plan subplan = mtstate->mt_plans[subplan_index]->plan; ^ make: [db2_fdw.o] Error 1**

Can someone please let me know if I have missed any steps for installing db2_fdw extension for Db2 on RHEL 7?

Thanks, Dhiraj Panjwani

[dpanjwani06]

Hi,

When trying to run the make command , I am getting the below error

*_-bash-4.2$ make install gcc -std=gnu99 -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Werror=vla -Wendif-labels -Wmissing-format-attribute -Wformat-security -fno-strict-aliasing -fwrapv -fexcess-precision=standard -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector-strong --param=ssp-buffer-size=4 -grecord-gcc-switches -m64 -mtune=generic -fPIC -g -fPIC -I/opt/KX/IBM/db2/insthome1/sqllib/include -I. -I./ -I/usr/pgsql-14/include/server -I/usr/pgsql-14/include/internal -D_GNU_SOURCE -I/usr/include/libxml2 -I/usr/include -c -o db2_fdw.o db2_fdw.c db2_fdw.c: In function db2_fdw_handler: db2_fdw.c:366:39: warning: assignment from incompatible pointer type [enabled by default] fdwroutine->AddForeignUpdateTargets = db2AddForeignUpdateTargets; ^ db2_fdw.c: In function "db2BeginForeignModify": db2_fdw.c:1628:26: error: "ModifyTableState" has no member named "mt_plans" Plan _subplan = mtstate->mt_plans[subplan_index]->plan; ^ make: *** [db2_fdw.o] Error 1__

Can someone please let me know if I have missed any steps for installing db2_fdw extension for Db2 on RHEL 7?

Thanks, Dhiraj Panjwani

We have Db2 V 11.1 and Postgresql V 14. These both DB's are on the same server

[wolfgangbrandl]

Hi The last tests for db2_fdw were on postgresql 12.x.  Can be that there has to be done some adaption for Version 14.  Can you adapt to Version 14? Which db2 Version are you using? Regards Wolfgang

----- Ursprüngliche Nachricht ----- Von: dpanjwani06 @.> Datum: 21.10.2021 12:13 An: wolfgangbrandl/db2_fdw @.> Kopie: Subscribed @.***> Betreff: [wolfgangbrandl/db2_fdw] Error in Execution of Make command on Postgre Sql V 14 (Issue #33)   >

 

Hi,

When trying to run the make command , I am getting the below error

*-bash-4.2$ make install gcc -std=gnu99 -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Werror=vla -Wendif-labels -Wmissing-format-attribute -Wformat-security -fno-strict-aliasing -fwrapv -fexcess-precision=standard -O2 -g -pipe -Wall -Wp, -D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector-strong --param=ssp-buffer-size=4 -grecord-gcc-switches -m64 -mtune=generic -fPIC -g -fPIC -I/opt/KX/IBM/db2/insthome1/sqllib/include -I. -I./ -I/usr/pgsql-14/include/server -I/usr/pgsql-14/include/internal -D_GNU_SOURCE -I/usr/include/libxml2 -I/usr/include -c -o db2_fdw.o db2_fdw.c db2_fdw.c: In function \u2018db2_fdw_handler\u2019: db2_fdw.c:366:39: warning: assignment from incompatible pointer type [enabled by default] fdwroutine->AddForeignUpdateTargets = db2AddForeignUpdateTargets; ^ db2_fdw.c: In function \u2018db2BeginForeignModify\u2019: db2_fdw.c:1628:26: error: \u2018ModifyTableState\u2019 has no member named \u2018mt_plans\u2019 Plan subplan = mtstate->mt_plans[subplan_index]->plan; ^ make: *** [db2_fdw.o] Error 1

Can someone please let me know if I have missed any steps for installing db2_fdw extension for Db2 on RHEL 7?

Thanks, Dhiraj Panjwani

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub https://github. com/wolfgangbrandl/db2_fdw/issues/33, or unsubscribe <https: //github. com/notifications/unsubscribe-auth/ACMUXO6ETARCVUJIGWAXYHDUH7RTFANCNFSM5GN XWDJQ>. Triage notifications on the go with GitHub Mobile for iOS <https: //apps.apple.com/app/apple-store/id1477376905?ct=notification-email& mt=8&pt=524675> or Android https://play.google. com/store/apps/details?id=com.github.android& referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_sour ce%3Dgithub.

[devrimgunduz]

Hi @wolfgangbrandl ,

Any updates for PG 13 and 14 support?

Thanks!

[omensinger]

It works with PG 13.2 and DB2 v11.5.4.0 out of the box. But I get the same error message (see above) with PG 14.3.

[wolfgangbrandl]

I will make the upgrade in July August.

From: Devrim Gündüz @.> Reply to: wolfgangbrandl/db2_fdw @.> Date: Monday, 30. May 2022 at 21:48 To: wolfgangbrandl/db2_fdw @.> Cc: Wolfgang Brandl @.>, Mention @.***> Subject: Re: [wolfgangbrandl/db2_fdw] Error in Execution of Make command on Postgre Sql V 14 (Issue #33)

Hi @wolfgangbrandl ,

Any updates for PG 13 and 14 support?

Thanks!

— Reply to this email directly, view it on GitHub, or unsubscribe. You are receiving this because you were mentioned.Message ID: @.***>

[nileger]

Hi, any updates on this issue? I experience the same error for PostgreSQL 14.3

[wolfgangbrandl]

I have upgraded to Version 14

[wolfgangbrandl]

Hi, any updates on this issue? I experience the same error for PostgreSQL 14.3

I have upgraded to Version 14

[devrimgunduz-edb]

Thanks a lot @wolfgangbrandl ! I built and pushed packages.