November 9, 2018

Firebird Foreign Data Wrapper (FDW) | firebird_fdw 1.0.0 released

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.

Posted at 6:59 PM

Post a comment
address will not be displayed