EDB Technical Update for Postgres Advanced Server (Database Server 11.3.10)

This article was originally published on May 13, 2019

• Merge with community release 11.3.
  • More information about this and other fixes in community PostgreSQL can be found  https://www.postgresql.org/about/news/1939/ and https://www.postgresql.org/docs/11/release-11-3.html.
• Merge OpenSSL 1.0.2r library to address the items identified in Security Advisory 26-Feb-2019  - https://www.openssl.org/news/cl102.txt

• RM43887: ROMNUM with partitioning table by making sure rownum filter gets applied over Append node.
• RM43930: REASSIGN/DROP OWNED BY for synonym and directory objects. [Support ticket #855677]
• RM43047: Add support for synonym resolution to the type. [Support ticket #712701]
• RM43917: Fix for dbms_scheduler to set the job next run correctly. [Support ticket #851452]
• RM43903: ALTER USER MAPPING to treat obfuscated_password and password as same option. [Support ticket #847443]
• RM43923: Fix an issue with addition of timestamp and negative numbers. [Support ticket #853879]
• RM43956: SPL: Use localVarCxt to store trigger variable values.
• RM43952: Serialize tuple and index updates while exchanging statistics for partition during exchange partition. [Support ticket #864189]
• RM43939: Fix for server crash with edb_enable_pruning is true. [Support ticket #853578]
• RM43920: ecpg: Fixed 'C' multiline macro handling.
• RM43915: Fix for pg_dump/restore for VIEWs having DECODE expression by displaying implicit cast while deparsing DECODE expressions. [Support ticket #851791]
• RM43940: SPL: Fix server crash with ASSERT statement.
• RM41964: Preserve the shared dependencies on package in case of replace.
• RM41007: Quote nested sub-procedure name while deparsing it into a CREATE statement.
• RM41958: Qualify type name while deparsing package variable.

• EDB Postgres Enterprise Edition