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

This article was originally published on February 22, 2019

• Merge with community release 11.2
  • More information about this and other fixes in community PostgreSQL can be found https://www.postgresql.org/about/news/1920/ and https://www.postgresql.org/docs/11/release-11-2.html

• RM43886 Allow COMMIT/ROLLBACK in any function-like expressions invoked via CALL.
• RM43888 Fix possible server crash in bytea_smaller() and bytea_larger(). [Support Ticket #833954]
• RM41964 Fix possible pg_upgrade failure for databases containing DBMS_AQ queue tables.
• RM41971 Fix possible server crash when attempting to use named-parameter syntax to call a function whose arguments are unnamed.
• RM43593 Fix failure to dump triggers on child partitioned tables when upgrading from a version prior to v10.
• RM43843 Fix incorrect handling of IYYY mask when to_char() is used. [Support Ticket #823847]
• RM43832 Fix wrong answer when to_date() is used with the RR mask for with or during a year ending in 00. [Support Ticket #822321]
• RM43739 Fix possible cache lookup failure when accessing the definition of an object type from which an attribute has been dropped.
• RM43281 Don't permit modifications to aq_administrator_role, since it is a special role used by the database system. [Support Ticket #731149]
• Fix locking bug when renaming a redaction policy.
• Fix failure to apply insert performance optimization when inserting into a partitioned table.
• RM43809 Fix CREATE ROLE to honor NOSUPERUSER even when IDENTIFIED BY is specified. [Support Ticket #818138]

• EDB Postgres Enterprise Edition

• HTML:
  • https://www.enterprisedb.com/docs/en/11.0/EPAS_11_Inst_Linux/toc.html
  • https://www.enterprisedb.com/docs/en/11.0/EPAS_11_Inst_Windows/toc.html
• PDF:
  • https://get.enterprisedb.com/docs/EDB_Postgres_Advanced_Server_Installation_Guide_Linux_v11.pdf
  • https://get.enterprisedb.com/docs/EDB_Postgres_Advanced_Server_Installation_Guide_Windows_v11.pdf