Trying to build and getting compile error:

[gettes]

Trying to build per the readme for dynamodb_fdw and getting the following error:

2.906 g++ -Wall -Wpointer-arith -Wendif-labels -Wmissing-format-attribute -Wimplicit-fallthrough=3 -Wcast-function-type -Wshadow=compatible-local -Wformat-security -fno-strict-aliasing -fwrapv -O2 -I./jansson -DHAVE_STDINT_H=1 -Wno-suggest-attribute=format -std=c++11 -fPIC -fvisibility=hidden -fvisibility-inlines-hidden -I. -I. -I../../src/include -D_GNU_SOURCE -c -o deparse.o deparse.cpp
6.665 g++ -Wall -Wpointer-arith -Wendif-labels -Wmissing-format-attribute -Wimplicit-fallthrough=3 -Wcast-function-type -Wshadow=compatible-local -Wformat-security -fno-strict-aliasing -fwrapv -O2 -I./jansson -DHAVE_STDINT_H=1 -Wno-suggest-attribute=format -std=c++11 -fPIC -fvisibility=hidden -fvisibility-inlines-hidden -I. -I. -I../../src/include -D_GNU_SOURCE -c -o dynamodb_query.o dynamodb_query.cpp
8.349 dynamodb_query.cpp: In function ‘Datum dynamodb_convert_to_pg(Oid, int, Aws::DynamoDB::Model::AttributeValue)’:
8.349 dynamodb_query.cpp:532:66: error: cannot convert ‘text*’ {aka ‘varlena*’} to ‘JsonLexContext*’
8.349 532 | lex = makeJsonLexContext(result, false);
8.349 | ^~~~~~
8.349 | |
8.349 | text* {aka varlena*}
8.349 In file included from dynamodb_query.cpp:31:
8.349 ../../src/include/utils/jsonfuncs.h:41:59: note: initializing argument 1 of ‘JsonLexContext* makeJsonLexContext(JsonLexContext*, text*, bool)’
8.349 41 | extern JsonLexContext *makeJsonLexContext(JsonLexContext *lex, text *json, bool need_escapes);
8.349 | ~~~~~~~~~~~~~~~~^~~
9.784 make: *** [: dynamodb_query.o] Error 1

[mkgrgis]

@gettes , please tell us about your environment

• PostgreSQL version,
• reference to commit of this FDW. Have you downloaded from cdad523 ?
• proofs of existing listed 3rd party libraries like ls -la ...... include/something.h results.

[gettes]

Here is what I do per the dynamodb readme:
git clone https://github.com/postgres/postgres.git
cd postgres
git checkout -b REL_15_6
./configure
make
cd contrib
git clone https://github.com/pgspider/dynamodb_fdw.git
cd dynamodb
make

[mkgrgis]

Thanks, @gettes ! Good command sequence. But nothing about

• proofs of existing listed 3rd party libraries like ls -la ...... include/something.h results.

Look like you have no JsonLexContext* definition in current C includes because there are no 3rd part components from README.

[gettes]

i am building all this in a docker image. so whatever is there is from the build process.

[gettes]

oh... i also have installed oracle_fdw and multicorn.

[gettes]

The include directory you are referencing... specifically where?

[gettes]

The postgres/src/include has the following in it:
access catalog datatype foreign lib meson.build parser pg_config_ext.h.in pg_config_manual.h pgtar.h portability postgres.h rewrite statistics utils
archive c.h executor funcapi.h libpq miscadmin.h partitioning pg_config_ext.h.meson pg_config_os.h pgtime.h port.h postmaster snowball storage varatt.h
backup commands fe_utils getopt_long.h Makefile nodes pch pg_config.h pg_getopt.h pg_trace.h postgres_ext.h regex stamp-ext-h tcop windowapi.h
bootstrap common fmgr.h jit mb optimizer pg_config_ext.h pg_config.h.in pgstat.h port postgres_fe.h replication stamp-h tsearch

[gettes]

I should also note I am trying to build inside the hub.docker.com/postgres/postgres:15.6 image.

[mkgrgis]

@gettes , 100% PostgreSQL docker image have no needed include files from listed additional components. I don't know where this includes should be inside of docker image. But without this components this FDW does not work and does not compiles.

[gettes]

When you build the aws sdk - do you build the entire sdk or just dynamodb? I have been building with just dynamodb and now I am trying with everything. Building the full sdk is slow. I am hoping to do BUILD_ONLY.

[mkgrgis]

When you build the aws sdk - do you build the entire sdk or just dynamodb?

Unfortunately I have no compile experience for this FDW, but some members of pgspider team doses. I know also there is no compilation without libcurl, openssl, libuuid.

[mkgrgis]

@t-hiroshige , could you please help with the issue?

[gettes]

and maybe seeing how you build the aws sdk would also be helpful in narrowing this down. I have tried building with lex;dynamodb and i get the same error. now i see that lex appears to have nothing to do with building this stuff - lex appears to be voice related.

[gettes]

With everything i have been trying - I am at the point where this is not an include library issue nor a pre-req issue but a coding problem. the original post is still the issue.

[gettes]

The code related to this changed in postgres in 10/2023. See
postgres/postgres@1c99cde