search

credativ / informix_fdw

Foreign Data Wrapper for Informix Databases
Other
28 stars 5 forks source link

PGSQL - 15 #37

Open PiotrKOT79 opened 1 year ago

PiotrKOT79 commented 1 year ago

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 commented 1 year ago

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 commented 1 year ago

Additional note to your other questions:

Vanilla PG15 is fully supported.

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

https://github.com/credativ/informix_fdw/commit/d52ed9f022539eecec3f7b9733ece8f7e079b74e

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