18.1.1 fixing issues and stabilize new functions

What's Changed

• Delete .vscode directory by @temuenz in #95
• Fix #85: Segmentation fault with aggregate functions by @rpx99 in #94
• Fix DB2 SAVEPOINT syntax to include required ON ROLLBACK RETAIN CURSOR by @xtremexp in #98
• Fix segmentation fault when using JWT authentication without user by @rpx99 in #101
• Initial approach for a CI/CD integrationtest by @sebasmannem in #81
• parameters need to be allocated otherwise they get overridden by subs… by @temuenz in #103
• fixing docker compose by @temuenz in #104

New Contributors

• @xtremexp made their first contribution in #98

Full Changelog: 18.1.0...18.1.1

What's Changed

• Delete .vscode directory by @temuenz in #95
• Fix #85: Segmentation fault with aggregate functions by @rpx99 in #94
• Fix DB2 SAVEPOINT syntax to include required ON ROLLBACK RETAIN CURSOR by @xtremexp in #98
• Fix segmentation fault when using JWT authentication without user by @rpx99 in #101
• Initial approach for a CI/CD integrationtest by @sebasmannem in #81
• parameters need to be allocated otherwise they get overridden by subs… by @temuenz in #103
• fixing docker compose by @temuenz in #104
• Fix JWT authentication for SELECT queries on foreign tables by @rpx99 in #107
• the repo has moved to pg-fdw by @temuenz in #108

New Contributors

• @xtremexp made their first contribution in #98

Full Changelog: 18.1.0...18.1.1

18.1.0 introduces JWT, truncate, copy from and bulk insert

New features in 18.1.0

• db2_fdw 18.1.0 now enables the use of Json Web Tokens, since DB2 v11.5.9+ supports it. Find more details on that on the github wiki of this project and in JWT_AUTHENTICATION.md
• db2_fdw 18.1.0 now supports truncate command. That command efficiently and quickly empties a remote table
• db2_fdw 18.1.0 now supports loading a remote table using the PG COPY FROM command. It's only been tested using CSV format, yet.
• db2_fdw has always been supporting COPY TO command exporting data from a fdw table to a local file.
• db2_fdw 18.1.0 has now basic support for bulk inserts. More enhancements in this are will follow, to truely expedite insert performance particularly on bulk inserts.

More Detailed Changeds* #79 checking for a LOB null value by @temuenz in #80

• Add JWT token authentication support as alternative to user/password by @rpx99 in #83
• prepare release 18.1.0 by @temuenz in #86
• Support for copy by @temuenz in #87
• Support foreign truncate by @temuenz in #90
• Cleanup use of malloc, palloc, palloc0,free and pfree by @temuenz in #91
• Add bulk insert support by @temuenz in #92

New Contributors

• @rpx99 made their first contribution in #83

Full Changelog: 18.0.1...18.1.0

18.0.1

The problem in the preporcessor compares for PG 18 required an immediate fixrelease.

What's Changed

• another version number by @temuenz in #73
• fixing the preprocessor compares for PG18 by @temuenz in #74

Full Changelog: 18.0.0...18.0.1

18.0.0-fix

Sorry, but I am still learning where version numbers all need to be increased, properly.

What's Changed

• another version number by @temuenz in #73

Full Changelog: 18.0.0...18.0.0-fix

18.0.0

What's New

Some datatype mappings (bold) have been changed.

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	text
SQL_VARGRAPHIC	text
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, 17 and 18, assuming it will also work with earlier versions of PostgreSQL.

What's Changed

• #61 stack smashing detected by @temuenz in #62
• Buffer safe strcpy by @temuenz in #64
• Fixes #66: vargraphic should be TEXT, not BYTEA by @sebasmannem in #69
• Fixes #67: wrong index passed to db2GetLob from convertTuple by @sebasmannem in #68
• Pg18 support by @temuenz in #70
• pg18-release files by @temuenz in #71
• update makefile by @temuenz in #72

New Contributors

• @sebasmannem made their first contribution in #69

Full Changelog: 17.0.0...18.0.0

17.0.0

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

db2_fw 7.0.0

db2_fdw working with postgres 17

DB2 Data Wrapper

This release was first distributed on PGXN