EDB Postgres Advanced Server 17.2 release notes v17
Released: 22 Nov 2024
EDB Postgres Advanced Server 17.2 includes the following enhancements and bug fixes:
Deprecation
With the release of EPAS 17, the DRITA is being deprecated and will not be included in EPAS 18. This decision follows the introduction of EDB’s PWR and edb_wait_states extensions, which offer improved diagnostic capabilities compared to DRITA. These new extensions provide a diagnostic experience more closely aligned with Oracle’s AWR reports, making DRITA obsolete.
Note
The pgAgent and adminpack packages are end of life from EPAS 17 and later.
| Type | Description | Category |
|---|---|---|
| Upstream merge | Merged with community PostgreSQL 17.2. See the PostgreSQL 17 Release Notes for more information. | |
| Feature | Added support for the Oracle-compatible BFILE native datatype and the DBMS_LOB package APIs. See the DBMS_LOB for more information. | |
| Feature | Added support for the Oracle-compatible DBMS_XMLDOM package to provide interface for HTML and XML documents. See the DBMS_XMLDOM for more information. | |
| Feature | Added support for the Oracle-compatible DBMS_ASSERT package to validate input properties and sanitize user input, thereby reducing the risk of SQL injections. See the DBMS_ASSERT for more information. | |
| Feature | Added support for the Oracle-equivalent NLS_UPPER,NLS_LOWER, and NLS_INITCAP functions. See the NLS functions for more information. | |
| Feature | Implemented alteruser utility to modify roles in the clusters. See the alteruser utility for more information. | |
| Enhancement | Added support for the Oracle-compatible FORALL..MERGE and FORALL..SAVE EXCEPTIONS. See the FORALL statement for more information. | |
| Enhancement | Added support for the XMLType data type to be called as an object type and has predefined member functions and constructors on it. See the XMLType datatype for more information. | |
| Enhancement | Added support for JSON log format in the EDB Auditing. This enables to create audit reports in XML, CSV, or JSON format. | |
| Enhancement | Added support for READ and WRITE privileges for the directory objects. | |
| Enhancement | Added support for READ and WRITE directory permissions in UTL_FILE APIs. | |
| Enhancement | Implemented IMPORT FOREIGN SCHEMA. This command imports a foreign schema from a foreign server or a database link. | |
| Enhancement | Added support for ANYCOMPATIBLE and "any" pseudo type to NVL function. This allows NVL function to support more types of argument combinations now. | |
| Enhancement | Added support to audit all the EDB Postgres Advanced Server's modified external function signatures so that PostgreSQL compatible extensions can be compiled along with EDB Postgres Advanced Server. | |
| Enhancement | EDB*Loader: Enhanced terminator and delimiter matching behavior to consider the server encoding. |