Firebird Foreign Data Wrapper (FDW)

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.

firebird_fdw is now available as version 0.5.0.

This update provides following new features:

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

This release requires Firebird API wrapper libfq version 0.3.0 (which has not been modified since the previous firebird_fdw release).

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

This release has been developed and tested with Firebird 2.5. It will work with Firebird 3.0, but does not yet take advantage of any new features; future releases will hopefully address this.

It is compatible with PostgreSQL versions 9.2 ~ 10, and should work with the upcoming version 11 release.

firebird_fdw is now available as version 0.4.0.

This update, together with an update of the underlying Firebird API wrapper libfq to version 0.3.0, is a general cleanup/bugfix release, with improvements including:

• new function firebird_fdw_version()
• bug in INSERT ... RETURNING ... fixed
• miscellaneous minor bug fixes and code cleanup
• TAP regression tests have been added

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

This release has been developed and tested with Firebird 2.5. It will work with Firebird 3.0, but does not yet take advantage of any new features; future releases will hopefully address this.

It is compatible with PostgreSQL versions 9.2 ~ 10, and should work with the upcoming version 11 release.

After a long hiatus, I've finally found time to update firebird_fdw, which is now available as version 0.3.0.

This update, together with an update of the underlying Firebird API wrapper libfq to version 0.2.0, is a general cleanup/bugfix release, with improvements including:

• support for PostgreSQL 9.6 and 10
• support for IMPORT FOREIGN SCHEMA (PostgreSQL 9.5 and later)
• automatic reconnection to Firebird
• improved error message handling and display
• improved memory handling and prevention of various unhandled situations which caused the PostgreSQL server to crash

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

This release has been developed and tested with Firebird 2.5. It will work with Firebird 3.0, but does not yet take advantage of any new features; future releases will hopefully address this.