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

This article was originally published on February 14, 2020

Technical Update
EDB Postgres Advanced Server (Database Server 12.2.3)

WHAT’S NEW
This update is notifying you of a new software release EDB Postgres™ Advanced Server 12.2.3. EDB Postgres Advanced Server 12 is built on open-source PostgreSQL 12, which introduces myriad enhancements that enable databases to scale up and scale out in more efficient ways. PostgreSQL 12 builds upon the existing partitioning techniques by allowing faster partition pruning along with additional partition improvements, several btree index advancements, CTE inlining, SERIALIZABLE for parallel query and many new features and capabilities.

Highlights of 12.2.3 release include:

Merge with community release 12.2.
- More information about this and other fixes in community PostgreSQL can be found https://www.postgresql.org/about/news/2011/ and https://www.postgresql.org/docs/12/release-12-2.html.
On Windows, SSL support is now provided through SafeLogic OpenSSL (1.0.2u).

This update contains the following fixes:

RM44151 - Skip expression simplification while fetching cursor rowtype. [#940052]
RM44174 - Disable partition pruning while fetching a cursor rowtype. [#950257]
RM44155 - Fixed execution of empty statements via expired accounts. [#942512]
RM44128/DB-132 - Fix server crash in interval partitioning with CLOBBER_CACHE_ALWAYS build
RM44175/DB-228 - Allow altering only its own password when expired while using password profiles.
RM44123 - Fixed handling of subtypes in the extended protocol.
RM44176 - Suppress error detail when password expire is set to infinity while using password profiles.
RM44108 - Clear rolpasswordsetat when a user is renamed.
RM44164 - Fixed invalid memory context handling inside switchToVariableContext().
RM44109 - Fixed CREATE TRIGGER .. AUTHORIZATION behavior to avoid potential pg_upgrade failures.
RM44129 - Fixed TAP testcase failure.
RM44141 - Fixed DROP TRIGGER by name behavior for statement-level triggers.
RM44130 - Fixed makeConst() call arguments order correctly in parse_spl_var().
RM44118 - Change datatype from int to double to avoid wrap around in password profile.

*References in the square brackets are the customer case numbers.

IS THIS FOR ME?
This announcement is for EDB customers who are using, or are interested in, EDB Postgres Advanced Server and have a database subscription purchased for:

EDB Postgres Enterprise Edition

HOW TO GET THE SOFTWARE
EDB Postgres Advanced Server v12 is packaged and delivered as a series of interactive installers available via Stackbuilder Plus and on the EnterpriseDB website. Visit:
https://www.enterprisedb.com/advanced-downloads

RPM Packages are available for download from:
https://yum.enterprisedb.com/

Debian/Ubuntu Packages are available for download from:
https://apt.enterprisedb.com/

To request the credentials required to access EnterpriseDB repositories, please visit https://www.enterprisedb.com/repository-access-request
Documentation is provided on the EnterpriseDB website. Visit:
https://www.enterprisedb.com/resources/product-documentation

TROUBLESHOOTING
If you experience any problems installing the new software please contact Technical Support at:
Email: support@enterprisedb.com
Phone: US: +1-732-331-1320 or 1-800-235-5891
UK: +44-2033719820
Brazil: +55-2139581371
India: +91-20-66449612

Search

Was this article helpful?