PGSQL - 15

[PiotrKOT79]

Hello

I am trying to run informix_fdw on postgresql version 15.
When I run the following scripts as instructed, I get the following errors:

pg_to_infomix=# CREATE FOREIGN TABLE foo (
id integer,
value integral
)
SERVER ol_testifx
OPTIONS ( query 'SELECT * FROM foo',
database 'm2m2',
informixserver 'ol_testifx',
informixdir '/Applications/IBM/informix'
);
ERROR: invalid option "informixserver"
HINT: Valid options in this context are: database,query,table,gl_datetime,gl_date,client_locale,db_locale,db_monetary,disable_predicate_pushdown,disable_rowid,enable_blobs

My question is whether this is related to the lack of support for the postgresql 15 database. The second question is whether anyone has successfully run informix-fdw on the enteprisedb version.

[psoo]

Pls attach the informixdir and informixserver option to the CREATE SERVER statement only and delete them from your statement for CREATE FOREIGN TABLE.

This was changed a while ago and wasn't reflected in the README, which is a bug, i am sry. I am going to update it.

[psoo]

Additional note to your other questions:

Vanilla PG15 is fully supported.

As of EDB, there is experimental build support as of this commit:

d52ed9f

Please read the instructions in the commit message carefully. There might be unresolved issues since this is a road less travelled and experimental.