October 17, 2020

Firebird Foreign Data Wrapper (FDW) | firebird_fdw 1.2.0 released

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.

Posted at 5:52 AM

Post a comment
address will not be displayed