firebird_fdw, a foreign data wrapper for PostgreSQL providing read and write access to Firebird databases, 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
- 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
- ERROR log messages will show any relevant Firebird query as a CONTEXT message
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. It supports Firebird 2.5.x and Firebird 3.0.x.
Source code is available from the GitHub repository: https://github.com/ibarwick/firebird_fdw/
CentOS rpm packages are available via the Fedora Copr build system.
