firebird_fdw 1.2.0
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 serverfirebird_version()
- shows Firebird version information for eachfirebird_fdw
foreign server in the current database
Following bugs have been fixed:
EXPLAIN
for a remote modify now shows the Firebird query usedUPDATE
statements where aBEFORE ROW UPDATE
trigger is present now work correctlyCREATE SERVER
'sport
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.
Links
- PGXN: firebird_fdw 1.2.0
- GitHub: firebird_fdw