What's New
db2_fdw has been rewritten to use sqlcli api instead of oci api.
Some more datatypes have been introduced with the new code.
| SQL Datatype | PG Datatype |
|---|---|
| SQL_CHAR | character |
| SQL_VARCHAR | character varying |
| SQL_LONGVARCHAR | text |
| SQL_BLOB | bytea |
| SQL_DBCLOB | text |
| SQL_CLOB | text |
| SQL_GRAPHIC | bytea |
| SQL_VARGRAPHIC | bytea |
| SQL_LONGVARGRAPHIC | bytea |
| SQL_BOOLEAN | boolean |
| SQL_INTEGER | integer |
| SQL_SMALLINT | smallint |
| SQL_BIGINT | bigint |
| SQL_NUMERIC | numeric |
| SQL_DECIMAL | decimal |
| SQL_REAL | real |
| SQL_DOUBLE | double precision |
| SQL_FLOAT | float |
| SQL_DECFLOAT | float |
| SQL_TYPE_DATE | date |
| SQL_TYPE_TIME | time |
| SQL_TYPE_TIMESTAMP | timestamp |
| SQL_TYPE_TIMESTAMP_WITH_TIMEZONE | timestamp with time zone |
| SQL_XML | xml |
| SQL_BINARY | bytea |
| SQL_VARBINARY | bytea |
| SQL_LONGVARBINARY | bytea |
The version number now indicates up to which version of PostgreSQL is supported. Currently the code has been built and tested with PostgreSQL 16 and 17, assuming it will also work with earlier versions of PostgreSQL.
What's Changed
- Sqlcli api by @temuenz in #58
- remove sql files for older versions by @temuenz in #59
- changed generated to Thomas Muenz by @temuenz in #60
Full Changelog: 7.0.0...17.0.0