firebird_fdw - A Firebird Foreign Data Wrapper (FDW)

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 to Firebird
• 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.

Basic RPM packages for RHEL and co. 7/8 and PostgreSQL 10 ~ 15 are available via the Copr build system:

• https://copr.fedorainfracloud.org/coprs/ibarwick/firebird_fdw/
• https://copr.fedorainfracloud.org/coprs/ibarwick/libfq/

More comprehensive packages will be available via the PGDG community repository at some point in the next couple of weeks.

Beginning with release 1.2.1, RPM packages for firebird_fdw are available via the PostgreSQL community YUM repository. This increases the number of distributions/distribution versions/architectures  for which firebird_fdw is available (particulary Fedora and Centos 8) and makes it easy to install firebird_fdw alongside other PostgreSQL packages.

Currently packages are available for:

• PostgreSQL 13
• PostgreSQL 12
• PostgreSQL 11
• PostgreSQL 10

Packages for PostgreSQL 9.5 and PostgreSQL 9.6 remain available via the existing copr repository (albeit for CentOS 6 and CentOS 7 only).

My thanks to Devrim Gündüz for setting this up.

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.

firebird_fdw is now available as version 1.1.0.

This release provides following new features:

• support for PostgreSQL 12 (tested against PostgreSQL 12beta1)
• following utility functions:
  • firebird_fdw_close_connections()
  • firebird_fdw_diag()

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

It is compatible with PostgreSQL versions 9.2 ~ 11, and PostgreSQL 12beta1.

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

firebird_fdw is now available as version 1.0.0.

This update provides following new features:

• 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 Firebird API wrapper libfq version 0.4.0 (this is a new libfq release with support for the Firebird 3 BOOLEAN datatype).

It is compatible with PostgreSQL versions 9.2 ~ 11.

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

NOTE currently no RPM packages are available for RHEL/CentOS 7 and PostgreSQL 11, due to issues encountered with using clang in the copr build system (this is related to the LLVM JIT functionality being enabled in the PGDG build). This is now fixed.