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.
| Type | Description | Category |
|---|---|---|
| Upstream merge | Merged with community PostgreSQL 16.1. See the PostgreSQL 16 Release Notes for more information. | |
| Feature | Added 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. | |
| Feature | Added support for two timezone functions: DBTIMEZONE and SESSIONTIMEZONE. See the TIMEZONE functions for more information. | |
| Feature | Added support for the Oracle-compatible NANVL function. See the NANVL function for more information. | |
| Feature | Added support for the Oracle-equivalent LNNVL() function. See the LNNVL function for more information. | |
| Feature | Added support for the Oracle-compatible DUMP SQL function. See the DUMP function for more information. | |
| Feature | Added support for the Oracle-compatible NLS CHARSET functions. See the NLS functions for more information. | |
| Feature | Added support for few more subprograms of DBMS_SQL package to ease the migrations. See the DBMS_SQL package for more information. | |
| Feature | Added spl_check extension to check and report errors for the EDB SPL language. See the spl_check for more information. | |
| Enhancement | Added support for UTL_FILE subprograms to ease the migrations. See the utl_file for more information. | |
| Enhancement | Transparent data encryption (TDE) now supports the AES key length 256 option to TDE. | |
| Enhancement | Added 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. | |
| Enhancement | The (ORDERED, NULL) upperrel operations are now performed remotely through OCI DBlink, which is responsible for evaluating the query’s ORDER BY ordering. | |
| Enhancement | Implemented MULTISET INTERSECT UNIQUE/DISTINCT and MULTISET EXCEPT UNIQUE/DISTINCT now for SPL collection types. | |
| Enhancement | You can now use the BULK COLLECT clause with a FETCH statement. | |
| Enhancement | Added synonym support for packages. | |
| Enhancement | The TO_TIMESTAMP_TZ() function now takes a single argument that converts a string to TIMESTAMPTZ in the default format. | |
| Enhancement | The 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. |