EDB Postgres Advanced Server 16.1 release notes v16

Released: 09 Nov 2023

EDB Postgres Advanced Server 16.1 includes the following enhancements and bug fixes:

Deprecation

This release removes support for Index Advisor and edb_enable_pruning GUC parameter. Index Advisor features are now included in the EDB Query Advisor.

TypeDescriptionCategory
Upstream mergeMerged with community PostgreSQL 16.1. See the PostgreSQL 16 Release Notes for more information.
FeatureAdded support for Oracle-compatible DBMS_PRIVILEGE_CAPTURE package and the SQL commands to define the capture privilege policy. See the DBMS_PRIVILEGE_CAPTURE for more information.
FeatureAdded support for two timezone functions: DBTIMEZONE and SESSIONTIMEZONE. See the TIMEZONE functions for more information.
FeatureAdded support for the Oracle-compatible NANVL function. See the NANVL function for more information.
FeatureAdded support for the Oracle-equivalent LNNVL() function. See the LNNVL function for more information.
FeatureAdded support for the Oracle-compatible DUMP SQL function. See the DUMP function for more information.
FeatureAdded support for the Oracle-compatible NLS CHARSET functions. See the NLS functions for more information.
FeatureAdded support for few more subprograms of DBMS_SQL package to ease the migrations. See the DBMS_SQL package for more information.
FeatureAdded spl_check extension to check and report errors for the EDB SPL language. See the spl_check for more information.
EnhancementAdded support for UTL_FILE subprograms to ease the migrations. See the utl_file for more information.
EnhancementTransparent data encryption (TDE) now supports the AES key length 256 option to TDE.
EnhancementAdded the edb_job_scheduler extension, which provides a background process that does the job scheduling for the DBMS_SCHEDULER and DBMS_JOB packages. Before, these packages were dependent on pgAgent. With this extension, packages don't have that dependency. See the EDB Job Scheduler extension for more information.
EnhancementThe (ORDERED, NULL) upperrel operations are now performed remotely through OCI DBlink, which is responsible for evaluating the query’s ORDER BY ordering.
EnhancementImplemented MULTISET INTERSECT UNIQUE/DISTINCT and MULTISET EXCEPT UNIQUE/DISTINCT now for SPL collection types.
EnhancementYou can now use the BULK COLLECT clause with a FETCH statement.
EnhancementAdded synonym support for packages.
EnhancementThe TO_TIMESTAMP_TZ() function now takes a single argument that converts a string to TIMESTAMPTZ in the default format.
EnhancementThe EXPAND_SQL_TEXT procedure of the DBMS_UTILITY package is now supported. It returns an expanded version of a given SQL query by replacing view references with its definition.