firebird_fdw 1.4.0

firebird_fdw is now available as version 1.4.0.

This version provides compatibility with the upcoming PostgreSQL 17 release, as well as the following new features:

• Basic support for UUID datatype
• Proper support for Firebird TIME/TIMESTAMP datatypes
• Support for Firebird TIME WITH TIME ZONE / TIMESTAMP WITH TIME ZONE datatypes
• Support for importing Firebird INT128 datatype

In addition, following bugfixes are included:

• Import Firebird FLOAT as PostgreSQL REAL
• Fix generated columns support

This release requires Firebird API wrapper libfq version 0.6.0 or later.

firebird_fdw 1.4.0 is compatible with PostgreSQL versions 9.5 ~ 17.

firebird_fdw 1.3.1

firebird_fdw is now available as version 1.3.1.

This release provides compatibility with the upcoming PostgreSQL 16 release.

firebird_fdw 1.3.1 is compatible with PostgreSQL versions 9.5 ~ 16.

firebird_fdw 1.3.0

firebird_fdw is now available as version 1.3.0.

This release provides following new features:

• support for PostgreSQL 15
• basic support for TRUNCATE (PostgreSQL 14 and later)
• support for batch inserts via COPY (PostgreSQL 14 and later)

and some improvements for existing functionality:

• improved mapping of PostgreSQL server encodings
• various fixes and improvements for IMPORT FOREIGN SCHEMA

This release requires Firebird API wrapper libfq version 0.5.0 or later.

firebird_fdw 1.3.0 is compatible with PostgreSQL versions 9.5 ~ 15. Note that support for PostgreSQL 9.3 and 9.4 has been removed in this release.

firebird_fdw 1.2.3

This is a minor release, providing a single bugfix:

• Fix bug in rescan handling (identified via GitHub #21)

A new libfq version (0.4.3) has been release at the same time, containing an unrelated bugfix.

firebird_fdw 1.2.2

This is a minor release, providing PostgreSQL 14 support and a number of minor bugfixes and improvements:

• support for API changes introduced during the PostgreSQL 14 release cycle which were backported as far back as PostgreSQL 11
• support for versions earlier than PostgreSQL 9.3 removed
• ensure non-superusers can execute firebird_version()
• enable provision of custom Firebird port for TAP tests
• invalid Firebird server port numbers will be rejected

firebird_fdw 1.2.1

This is a minor release, mainly to fix a build issue in recent Fedora versions.

Links

• PGXN: firebird_fdw 1.2.1
• GitHub: firebird_fdw

firebird_fdw 1.2.0

firebird_fdw is now available as version 1.2.0.

This release provides following new features:

• support for PostgreSQL 13
• support for generated columns (PostgreSQL 12 and later)
• support for COPY and partition tuple routing (PostgreSQL 11 and later)
• improved handling of case folding/identifier quoting between PostgreSQL and Firebird
• support for "implicit booleans"
• pushdown of boolean tests in WHERE clauses (including implicit booleans)
• following utility functions have been added:
  • firebird_fdw_server_options(servername TEXT) - displays the current settings for the named server
  • firebird_version() - shows Firebird version information for each firebird_fdw foreign server in the current database

Following bugs have been fixed:

• EXPLAIN for a remote modify now shows the Firebird query used
• UPDATE statements where a BEFORE ROW UPDATE trigger is present now work correctly
• CREATE SERVER's port option is now recognized
• foreign tables defined as queries can no longer be set as updatable = 'true'

This release requires Firebird API wrapper libfq version 0.4.0 or later (latest version at the time of writing: 0.4.2)

firebird_fdw 1.2.0 is compatible with PostgreSQL versions 9.3 ~ 13. Note that support for PostgreSQL 9.2 has been removed in this release.

CentOS rpm packages are available via the Fedora Copr build system.

Links

• PGXN: firebird_fdw 1.2.0
• GitHub: firebird_fdw

firebird_fdw release 1.1.0

firebird_fdw 1.1.0 has been released with following changes:

• code updated for compatibility with PostgreSQL 12 (currently in beta)
• utility function firebird_fdw_close_connections() added
• utility function firebird_fdw_diag() added

This release requires libfq version 0.4.0 or later. It is compatible with PostgreSQL versions 9.2 ~ 12.

RPMs are available here:
https://copr.fedorainfracloud.org/coprs/ibarwick/firebird_fdw/

firebird_fdw release 1.0.0

firebird_fdw 1.0.0 has been released with following changes:

• Supports the Firebird BOOLEAN datatype (Firebird 3.0 and later)
• IMPORT FOREIGN SCHEMA implementation has been improved:
  • Firebird views can now also be imported (this can be controlled with the new option import_views)
  • verbose option will show which Firebird tables/views are being imported
  • updatable option can be used to control whether all imported tables/views are marked as updatable
  • import_null option determines whether column NOT NULL constraints are included in the definition of imported tables
• New table option estimated_row_count added
• Handling of foreign tables defined as Firebird queries has been improved
• PostgreSQL 11 is supported
• Code has been adapted to compile against current PostgreSQL HEAD
• A bug has been fixed where a segfault could occur if not all expected Firebird connection parameters were provided

This release requires libfq version 0.4.0. It is compatible with PostgreSQL versions 9.2 ~ 11.

RPMs are available here:
https://copr.fedorainfracloud.org/coprs/ibarwick/firebird_fdw/

firebird_fdw release 0.5.0

firebird_fdw 0.5.0 has been released with following changes:

• Firebird datatype BLOB SUB_TYPE TEXT is now supported.
• Foreign table triggers are now supported.

This release requires libfq version 0.3.0.

RPMs are available here:
https://copr.fedorainfracloud.org/coprs/ibarwick/firebird_fdw/