EDB Postgres Advanced Server Release Notes v14

New features, enhancements, bug fixes, and other changes in EDB Postgres Advanced Server 14 include:

Upstream MergeSee the PostgreSQL 14 Release Notes for more information. See also PostgreSQL 14 Open Items.
FeatureOracle CompatibilityAdded the SUBPARTITION TEMPLATE clause, so that there is no need to specify the subpartition descriptor or each partition. Specify the TEMPLATE once and it gets applied to every partition automatically.
FeatureOracle CompatibilityEnabled access to a partition by PARTITION (<partname>) or subpartition by SUBPARTITION (<subpartname>) clause, which allows the use of such clauses for SELECT, UPDATE, INSERT, and DELETE queries.
FeatureOracle CompatibilityAdded support for USERENV(), a function providing user environment and session related details.
FeatureOracle CompatibilityAdded support for bitwise AND and OR functions and aggregates operation on a numeric data type and added bitwise & and | operators for the numeric data types.
FeatureOracle CompatibilityAdded support for the NOCYCLE and ENABLE keywords.
FeatureOracle CompatibilityGeneralized CONNECT_BY syntax support:
- Allow the use of multiple PRIOR expressions.
- Use AND/OR with multiple conditions to allow any combination of Unary, Binary or Prior expressions.
- Use of Unary expressions.
- Make PRIOR optional with CONNECT BY query.
- Enhance the function to detect the cycle, so that it can work with multiple PRIOR expressions.
- Support PRIOR in the target list.
FeatureOracle CompatibilityEnhanced NVL2 to use ANYCOMPATIBLE pseudo-type. Allows the NVL2 function to support considerably more argument-type combinations. For example, the NVL2 version can match a call with one INTEGER and multiple BIGINT arguments and the INTEGER is automatically promoted to BIGINT. With the previous ANYELEMENT version, you had to cast the INTEGER explicitly.
FeatureOracle CompatibilityAdded traceability for when an object is created and last modified by a DDL operation.
FeatureOracle CompatibilityWhen a user tries to create a sequence with an upper boundary out of range, a warning message is logged.
FeatureOracle CompatibilityWhen a user creates a sequence specifying the NOORDER keyword, the keyword is considered a NOOP keyword and a warning message is logged which states that specifying the NOORDER keyword has no beneficial effect in EDB Postgres Advanced and is ignored.
FeatureOracle CompatibilityTrailing zeros with TO_CHAR(numeric) are removed to be more compatible with Oracle.
FeatureOracle CompatibilityAdded support for using an alias on table names in INSERT statements for accessing a partition or subpartition with SELECT, INSERT, UPDATE, or DELETE statements, so that the alias can be used to qualify the table columns. For example, INSERT INTO table_name t (t.col1) VALUES (10);
FeatureOracle CompatibilityEnhanced DBMS_SQL package functions to accept NUMBER instead of INTEGER so that both INTEGER to NUMBER functions can accept both NUMBER and INTEGER type values. Since these functions are compatible with both NUMBER and INTEGER, EDB Postgres Advanced Server restricts the input range within the INTEGER's limit.
FeatureSecurityAdded support for selective auditing of objects for specific DML statements such as SELECT, INSERT, UPDATE, or DELETE and to specify either include (@) or exclude (-) particular statement type for a relation. For more information see Object Auditing.
FeatureSecurityAdded capability to control the space consumed by the audit log directory and to manage the audit log files, which can be configured through a new edb_audit_archiver configuration parameter. The edb_audit_archiver parameter helps in compressing the old audit log files by specifying the compression command and executing the command before removing the old audit log files.
FeatureSecurityProvided an option to audit the SET commands. To enable this you need to modify the log_statement GUC.
FeatureGeneral FunctionalityEnabled creation of ROWID columns with IMPORT FOREIGN SCHEMA.
FeatureGeneral FunctionalityBegan using global sequences for ROWID so that they are unique across the database and can be used on the partitioned tables.
FeatureGeneral FunctionalityAllowed dynamic partition creation to non-owner insert queries.
FeatureGeneral FunctionalityExtended \h support to work with EDB Postgres Advanced Server objects so that users can see the syntax on a psql prompt.
FeatureGeneral FunctionalityAdded tab-completion support for EDB Postgres Advanced Server syntaxes.