firebird_fdw - A Firebird Foreign Data Wrapper (FDW)
firebird_fdw
is a PostgreSQL foreign data wrapper (FDW) for the Firebird database.
Links
- GitHub: firebird_fdw
- libfq | libfq documentation
Beginning with release 1.2.1, RPM packages for firebird_fdw
are available via the PostgreSQL community YUM repository. This increases the number of distributions/distribution versions/architectures for which firebird_fdw
is available (particulary Fedora and Centos 8) and makes it easy to install firebird_fdw
alongside other PostgreSQL packages.
Currently packages are available for:
- PostgreSQL 13
- PostgreSQL 12
- PostgreSQL 11
- PostgreSQL 10
Packages for PostgreSQL 9.5 and PostgreSQL 9.6 remain available via the existing copr repository (albeit for CentOS 6 and CentOS 7 only).
My thanks to Devrim Gündüz for setting this up.
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
'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.
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 importedupdatable
option can be used to control whether all imported tables/views are marked as updatableimport_null
option determines whether columnNOT NULL
constraints are included in the definition of imported tables
- Firebird views can now also be imported (this can be controlled with the new option
- 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 This is now fixed.clang
in the copr build system (this is related to the LLVM JIT functionality being enabled in the PGDG build).
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.