Firebird Fdw Versions Save

A PostgreSQL foreign data wrapper (FDW) for Firebird - latest version 1.3.1 (2023-06-22)

1.3.1

10 months ago

firebird_fdw is now available as version 1.3.1.

This release provides compatibility with the upcoming PostgreSQL 16 release.

firebird_fdw 1.3.1 is compatible with PostgreSQL versions 9.5 ~ 16.

1.3.0

1 year ago

firebird_fdw is now available as version 1.3.0.

This release provides following new features:

  • support for PostgreSQL 15
  • basic support for TRUNCATE (PostgreSQL 14 and later)
  • support for batch inserts via COPY (PostgreSQL 14 and later)

and some improvements for existing functionality:

  • improved mapping of PostgreSQL server encodings
  • various fixes and improvements for IMPORT FOREIGN SCHEMA

This release requires Firebird API wrapper libfq version 0.5.0 or later.

firebird_fdw 1.3.0 is compatible with PostgreSQL versions 9.5 ~ 15. Note that support for PostgreSQL 9.3 and 9.4 has been removed in this release.

1.2.3

2 years ago

This is a minor release, providing a single bugfix:

  • Fix bug in rescan handling (identified via GitHub #21)

A new libfq version (0.4.3) has been release at the same time, containing an unrelated bugfix.

1.2.2

2 years ago

This is a minor release, providing PostgreSQL 14 support and a number of minor bugfixes and improvements:

  • support for API changes introduced during the PostgreSQL 14 release cycle which were backported as far back as PostgreSQL 11
  • support for versions earlier than PostgreSQL 9.3 removed
  • ensure non-superusers can execute firebird_version()
  • enable provision of custom Firebird port for TAP tests
  • invalid Firebird server port numbers will be rejected

1.2.1

3 years ago

This is a minor release, mainly to fix a build issue in recent Fedora versions.

1.2.0

3 years ago

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.

1.1.0

4 years ago

firebird_fdw 1.1.0 has been released with following changes:

  • code updated for compatibility with PostgreSQL 12 (currently in beta)
  • utility function firebird_fdw_close_connections() added
  • utility function firebird_fdw_diag() added

This release requires libfq version 0.4.0 or later. It is compatible with PostgreSQL versions 9.2 ~ 12.

RPMs are available here: https://copr.fedorainfracloud.org/coprs/ibarwick/firebird_fdw/

1.0.0

5 years ago

firebird_fdw 1.0.0 has been released with following changes:

  • 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 libfq version 0.4.0. It is compatible with PostgreSQL versions 9.2 ~ 11.

RPMs are available here: https://copr.fedorainfracloud.org/coprs/ibarwick/firebird_fdw/

0.5.0

5 years ago

firebird_fdw 0.5.0 has been released with following changes:

  • Firebird datatype BLOB SUB_TYPE TEXT is now supported.
  • Foreign table triggers are now supported.

This release requires libfq version 0.3.0.

RPMs are available here: https://copr.fedorainfracloud.org/coprs/ibarwick/firebird_fdw/

0.4.0

5 years ago

firebird_fdw 0.4.0 has been released with following changes:

  • add function firebird_fdw_version()
  • add TAP tests
  • fix bug in INSERT ... RETURNING ...
  • miscellaneous minor bug fixes and code cleanup

This release requires libfq version 0.3.0.

RPMs are available here: https://copr.fedorainfracloud.org/coprs/ibarwick/firebird_fdw/