- Babelfish Version: 2.1.0a
- PostgreSQL Server Version: 14.3
- Download source distributions:
- Babelfish Compass
- Date: July 28, 2022
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.
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/
Support for functions:
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
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.
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.
Babelfish for PostgreSQL is open source software that uses the Apache License version 2 (ALv2) and PostgreSQL Licence. ALv2 grants you well-understood usage rights; you can use, modify, extend, embed, monetize, resell, and offer Babelfish for PostgreSQL as part of your products and services. The source for the entire project is available on GitHub and you’re welcome to build from source for customized deployments.Version: 2.1.0a
Release Date: Jul 28, 2022