Enterprise Postgres 17 SP1 Release Notes

(Collapse Contents)

Chapter 2 Compatibility Information

2.1 Installation/Setup Incompatibility

2.1.1 Removing Old llvm Support for JIT compilation

2.1.2 Removing Operating System Support for Client Feature

2.1.3 Removing Operating System Support for Server Feature

2.1.4 Removing Operating System Support for Server Assistant Feature

2.1.5 Python Version Changes Required When Using PL/Python

2.1.6 Perl Version Changes Required When Using PL/Perl

2.1.7 Modifying the Installation of pgBackRest

2.1.8 How max_wal_senders is calculated

2.1.9 How max_worker_processes is calculated

2.1.10 Removing Old llvm Support for JIT compilation

2.1.11 Removing Operating System Support

2.1.12 Changing kernel parameter settings when an instance is created with WebAdmin

2.1.13 Removing Operating System Support

2.1.14 Changing the Way OSS is Set Up

2.1.15 Modifying Pgpool-II Installation Handling

2.1.16 Changing Core and Log File Paths when Instance is Created with WebAdmin

2.1.17 Renaming WebAdmin Services

2.2 Application Migration Incompatibility

2.2.1 Changing the OID of the Data Type (NCHAR type) that Handles National Characters

2.2.2 Changing the display result when data masking is applied to NaN, infinity, -infinity

2.2.3 Changing the Valid Range of Identifiers Defined by the DECLARE STATEMENT statement

2.2.4 Changing Precompile Results

2.2.5 Changing the Trigger Replacement Process

2.2.6 Removing Java Support

2.2.7 Changed to Error when Running an Operator or Function that Returns non Data Types for Masking Type

2.3 Operation Migration Incompatibility

2.3.1 Deprecation of Some Encryption Algorithms in pgcrypto

2.3.2 Deprecation of Certificates Signed Using SHA1

2.3.3 Abolition of Message Numbers

2.3.4 Adding the key_name Column to the View pgx_tde_master_key

2.3.5 Changing the Output of the Status Mode of the cm_ctl Command

2.3.6 Rename column "master_pid" in pgx_loader_state to "leader_pid"

2.3.7 Adding a Message to Output when the Database Server watchdog detects that the Connection Manager is down

2.3.8 Change the Error Information when the Connection Manager re-executes SQL on the Failed Connection

2.3.9 Changing the Value of the Category Column in the pg_settings view

2.3.10 Changing pgx_stat_lwlock of the Statistics View

2.3.11 Changing the Behavior of pgx_rcvall

2.3.12 Mirroring Controller no Longer Retries to Monitor Database Processes when they are Detected as Down

2.3.13 Changing the Name and Parameter Name of the Mirroring Controller Post-Promote Command

2.3.14 Changing Mirroring Controller User Command Input Values

2.4 JDBC Driver Incompatibility

2.4.1 Changing the targetServerType Value

2.5 ODBC Driver Incompatibility

2.5.1 Cannot specify prefer-read for target_session_attrs

2.6 C Library (libpq) Migration Incompatibility

2.6.1 Changing when "prefer-read" is Specified for the target_session_attrs Parameter

2.7 oracle_fdw Incompatibility

2.7.1 Changing the Oracle Client Version

2.8 pg_statsinfo Incompatibility

2.8.1 Changing Simple Report Items

2.8.2 Change the Contents of the bgwriter Table in the statsrepo Schema

2.8.3 Rename Columns in statement Table in statsrepo Schema

2.8.4 Change the Default Value of the stattarget Column of the column Table in the statsrepo Schema

2.9 pgaudit Incompatibility

2.9.1 Repairing Unwanted Output in the Audit Log

2.9.2 Changing to Output Extra NEW and OLD Values in the Audit Log when the Trigger Function Executes

2.10 pg_dbms_stats Incompatibility

2.10.1 Change in Execution Plan due to Fixed Height of Btree index

2.10.2 Incompatibility of Import Features with Fixed Height of Btree index

2.11 orafce Incompatibility

2.11.1 Interface changes due to enhancements to the DBMS_SQL package

2.12 WebAdmin Incompatibility

2.12.1 Linux server behavior changes for login authentication

2.12.2 Changing the default value of the item 'Number of digits for floating values' which is set in the section 'SQL options'

2.12.3 Cannot specify prefer-read for target_session_attrs

2.13 Connection Manager Incompatibility

2.13.1 Behavior change when "read-write" is specified for the target_session_attrs parameter

2.14 Confidentiality Management Incompatibility

2.14.1 Changes due to Changes in the pg_dump Specification

2.14.2 Changing Permission Settings by Changing the CREATEROLE Permission

2.14.3 Change due to Restriction of CREATEROLE Privilege

Chapter 3 Program Updates

3.1 Fujitsu Enterprise Postgres 17 SP1 Program Updates

3.2 Fujitsu Enterprise Postgres 17Program Updates