Михаил

> I understood that the result of TC31 is error, but how about TC37 and TC38? > They should be OK, but they returned error instead. Yes. What about SpatiaLite...

> FYI, about OS, I'm using Rocky Linux 8.8. This should be normal environment. `libspatialite-devel` is also normal package. I am testing on Debian 12 with such result for the...

Look like some problem is in `listed_datatype` for different contexts. In my case filter of data type names works good, in your case, @son-phamngoc , maybe not.

@son-phamngoc , I think such PostGIS functions as `geometry_in` or `geometry(bytea)` and `geography_in` or `geography(bytea)` can be used in our case for input. `geometry_out` and `geography_out` functions are used for...

> Could you tell me why this PR only works with PostGIS 2+? Is there any reason that it cannot work with PostGIS 3+? @son-phamngoc, this PR should works also...

@son-phamngoc , some additional context **PostGIS for testing** - [Source codes](https://postgis.net/development/source_code/) and version matrix https://trac.osgeo.org/postgis/wiki/UsersWikiPostgreSQLPostGIS gives us `postgis-3.3.6.tar.gz` for PostgreSQL versions from tests of this FDW. - For Ubuntu environment...

> @mkgrgis I think if you cast data to bytea, bytea_out function will be called to print data, so possibly, no problem occurs. Yes. Now I have understood this is...

> Could you investigate and fix this PR, considering above problem? Yes, @son-phamngoc . Also I need help with testing environment. How can I enable PostGIS in testing databases? Just...

@son-phamngoc , after current fixed CI and `CREATE EXTENSION postgis;` in testing `postgis.sql` I have ``` ERROR: extension "postgis" is not available DETAIL: Could not open extension control file "/home/runner/work/sqlite_fdw/sqlite_fdw/workdir/postgresql-16.0/tmp_install/usr/local/pgsql/share/extension/postgis.control":...

@son-phamngoc , currently the main problem in CI is invisible `postgres.h` for unpacked to `./contrib/postgis-VER` PostGIS code. I think after this problem solving I'll can `CREATE EXTENSION postgis;` in sqlite_fdw...