PolarDB:2024 - PolarDB - Alibaba Cloud

This topic describes the release notes for PolarDB for PostgreSQL (Compatible with Oracle) and provides links to the relevant references.

Note

You can execute the following statement to view the minor engine version of your PolarDB for Oracle cluster:
```
SHOW polardb_version;
```
The revision version numbers of PolarDB for PostgreSQL (Compatible with Oracle) clusters changed to a 6-digit format on February 26, 2025 (UTC+8). For more information, see Revision version numbers changed to a 6-digit format.

November 2024

Minor version 1.1.43

Category	Feature	Description	References
New feature	New functions for processing strings are supported.	The regexp_replace, to_clob, and to_nchar functions for processing strings are supported	N/A
	New functions for processing XML data are supported.	The EXISTSNODE, EXTRACT, EXTRACTVALUE, DELETXML, and INSERTCHILDXML functions for processing XML data are supported	N/A
	DDL statements can be issued implicitly.	You can implicitly issue DDL statements.	N/A
	Autonomous transactions support COMMIT statements.	You can add COMMIT statements in autonomous transactions.	N/A
	`^=` is supported.	The `^=` operator is supported.	N/A
	UNION ALL NULL is supported in subqueries.	You can add UNION ALL NULL in subqueries.	N/A
	ENABLE constraints are supported for table creation statements.	You can add ENABLE constraints in table creation statements to ensure data integrity and accuracy.	N/A
	SAMPLE statements support aliases.	You can specify aliases for SAMPLE statements.	N/A
	ALTER TABLE statements for adding columns support parenthesized elements.	When you execute ALTER TABLE statements to add columns, you can use parenthesized elements.	N/A
Fixed issue	The log issue of the pg_cron extension is fixed.
Fixed issue	The polar_advisor extension creation issue is fixed.

Minor version 1.1.42

Category	Feature	Description	References
New feature	Case insensitivity is supported for functions and synonyms.	The case insensitivity feature applies to names of functions and synonyms.	Case insensitivity
	%TYPE is supported for some keywords.	You can use %TYPE for keywords like `by` to keep the type of a variable consistent with that of a table column.	N/A
	The INITIALIZED clause can be used in a CREATE CONTEXT statement.	You can use the INITIALIZED clause in a CREATE CONTEXT statement to set the initial state of context.	N/A
	The string_to_raw and raw_to_char functions of UTL_I18N are supported.	You can use the string_to_raw and raw_to_char functions of UTL_I18N for character set conversion.	N/A
Fixed issue	The following issue is fixed: The standby node fails to replay the `Global Index XLOG_BTREE_DELETE` logs.
Fixed issue	The following issue is fixed: The cluster crashes when the global index is used for `insert into on conflict`.

Minor version 1.1.41

Category	Feature	Description	References
Feature optimization	The performance of transactions that contain a large amount of DDL operations is optimized.	The default private cache of Global CatCache (GCC), Global RelCache (GRC) processes in PolarDB for PostgreSQL (Compatible with Oracle) is updated to optimize the performance of transactions that contain a large amount of DDL operations.	Global caches

Minor version 1.1.40

Category	Feature	Description	References
Feature optimization	`ON COMMIT DELETE ROWS` optimized in PolarDB for PostgreSQL (Compatible with Oracle)	`ON COMMIT DELETE ROWS` is optimized in PolarDB for PostgreSQL (Compatible with Oracle) to resolve the issue of slow commit when it is used on a large number of temporary tables.	N/A
Fixed issue	The following issue is fixed: Logindex file recycling in PolarDB for PostgreSQL (Compatible with Oracle) is affected by logical replication.
Fixed issue	The following issue is fixed: Reference count overflow in shared memory used by the Global Plan Cache (GPC) feature causes connection creation errors.

Minor version 1.1.39

Category	Feature	Description	References
New feature	Version upgrade of the GanosBase spatiotemporal database	The GanosBase spatiotemporal database is upgraded to version 6.4.	Release notes for GanosBase

Minor version 1.1.38

Category	Feature	Description	References
New feature	The built-in REPLICATION user group supported in PolarDB for PostgreSQL (compatible with Oracle)	By default, the privileged user in PolarDB for PostgreSQL (compatible with Oracle) has the pg_polar_replication permissions and can grant standard users the user group permissions (such as pg_polar_replication permissions) except for the pg_read_all_stats, pg_stat_scan_tables, and pg_signal_backend permissions. Such permissions allow data replication-related operations such as stream replication and log export.	Account permissions

Minor version 1.1.37

Category	Feature	Description	References
New feature	Replacing composite types supported	You can execute the `CREATE OR REPLACE TYPE` statement to rebuild a composite type.	CREATE TYPE