Documentation

Babelfish 2.1.0a

• Babelfish Version: 2.1.0a
• PostgreSQL Server Version: 14.3
• Download source distributions:
  • BABEL_2_1_0a__PG_14_3.zip
  • BABEL_2_1_0a__PG_14_3.tar.gz
• Babelfish Compass
  • Download
• Date: July 28, 2022

Overview

Babelfish 2.1.0a contains enhancements and fixes that improve the user experience, including:

• Support for new functions, catalogs, and system stored procedures.
• Support for Japanese collations.
• Improved client support.

Babelfish does not support an upgrade path to version 2.1.0a from Babelfish 1.x.x.

Changes

This version of Babelfish adds support for the following features:

• Backported the fix from the PostgreSQL 14.4 release that reverts changes to CONCURRENTLY that speed up Xmin advance to prevent index corruption with the CREATE INDEX CONCURRENTLY / REINDEX CONCURRENTLY commands.

• Support for functions: IS_MEMBER(), IS_ROLEMEMBER(), HAS_PERMS_BY_NAME().

• Support for the following catalogs:

• Support for the system stored procedures:

• Cross-DB references outside the current database, with a 3-part object name, for SELECT,SELECT..INTO, INSERT, UPDATE, DELETE CREATE ROLE (AUTHORIZATION clause not supported), DROP ROLE, ALTER ROLE.

• Support for the following collations: Japanese_CS_AS, Japanese_CI_AI, Japanese_CI_AS

• Babelfish now supports CHARINDEX() substring searches on systems using nondeterministic collations.

• Babelfish now maps the error code for @@ERROR=213.

• Query plan output is generated following SET BABELFISH_SHOWPLAN_ALL ON (and OFF) and SET BABELFISH_STATISTICS PROFILE ON (OFF). This will generate PostgreSQL-style query plan information for T-SQL queries in Babelfish. Note that these SET statements are identical to existing T-SQL statements, but with the added BABELFISH_ prefix.

• Support for data migration with the SSMS Import/Export Wizard.

• Support for data migration using the bcp client utility, as an experimental feature. Some bcp options (-b, -C, -E, -G, -h, -K, -k, -q, -R, -T, -V) are not currently supported.

• Support for connecting with the SSMS object explorer connection dialog (rather than only the Query Editor connection dialog), as well as partial support for the SSMS object explorer itself.

Acknowledgements

To see a list of the individuals that have contributed to the Babelfish project, visit the project website.

Babelfish for PostgreSQL is open-source software that uses the Apache License version 2 (ALv2) and the PostgreSQL License. The source for the project is available on GitHub.