This article was originally published on August 21, 2018
Technical UpdateEDB Postgres Advanced Server (Database Server 10.5.12)
This update is notifying you of a new software release EDB Postgres™ Advanced Server 10.5.12. EDB Postgres Advanced Server 10.0 is built on the open source PostgreSQL 10.0, which introduces an impressive number of improvements that enable databases to scale up and scale out in more efficient ways. PostgreSQL 10.0 introduces Native Partitioning, Logical Replication, SCRAM Authentication, additional Parallel Query capabilities as well as a host of other new features and capabilities.
Highlights of 10.5.12 release include:
- Merge with community release 10.5
- More information about this and other fixes in community PostgreSQL can be found https://www.postgresql.org/about/news/1878/ and https://www.postgresql.org/docs/10/static/release-10-5.html
- RM43664 - Fix SCRAM authentication on Windows with SafeLogic DLL.[Support Ticket #774343]
- RM43667 - Fix server crash on Windows when database containing password verify function is dropped. [Support Ticket #778591]
- RM43615 - ECPG: Treat "double" as regular "C" type instead of ecpg type. [Support Ticket #766415]
- RM43582 - ECPG PROC: Correct search path for system header files. [Support Ticket #714566]
- RM43674 - Fix issue where dblink_ora_copy ignores partition constraints.
- RM43608 - OCI DBLink: Use OCIPing to validate connection status to allow failover. [Support Ticket #761564]
- RM43658 - Fix server crash with CREATE partition syntax. [Support Ticket #774842]
- RM43621 - Reset lock wait timeout after successfully acquiring a lock. [Support Ticket #762664]
- RM43557 - Fix EDB partition pruning for parent and child table having different attribute number order.
- RM43495 - Fix dblink_ora_copy() to work with partitioned tables. [Support Ticket #751430]
- RM43541 - ECPG: Fix parsing elif block. [Support Ticket #714566, 763085]
- RM43519 - Pass correct charset form to OCI LOB API in dblink_ora module. [Support Ticket #754525]
- RM43568 - ECPG: Raise "no data found" error with usebulk option. [Support Ticket #697421]
- RM43564 - Fix EDB's PAM authentication so that it doesn't report an authentication failure in case of PAM_TEXT_INFO messages. [Support Ticket #758027]
- RM43531 - EDB audit: Fix file rotation for edb_audit_rotation_day option. [Support Ticket #758750]
- RM43563 - Fix EXCHANGE PARTITION to pass the actual relation name to validate the constraints. [Support Ticket #761902]
- RM43504 - Bulk API: Update command id in the active snapshot which fixes an issue with recursive queries. [Support Ticket #755194]
- RM43268 - Fix the edb-validator parser to use handle FOREACH. [Support Ticket #757821]
- RM43118 - Bulk API: Fix issue with UPDATE statement that doesn't affect rows when the SET clause uses a recursive subquery. [Support Ticket #717187]
- RM43354 - utl_mail: Fix error message reported by exception.
- RM43478 - dbms_alert: Error out if shared memory is not yet allocated.
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
This update is available from the EDB Postgres downloads website (https://www.enterprisedb.com/advanced-downloads) or via Stack Builder Plus.
This update is also available as an RPM package that can be downloaded from the yum.enterprisedb.com repository. To setup your credentials and gain access to the yum repository, please submit a request: https://www.enterprisedb.com/repository-access-request
Please review the Installation Guide for more details:
- HTML: https://www.enterprisedb.com/docs/en/10.0/EPAS_Inst_Guide_v10/toc.html
- PDF: https://get.enterprisedb.com/docs/EDB_Postgres_Advanced_Server_Installation_Guide_v10.pdf
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