However, these parameters are treated as IN OUT only, and there was previously no way to specify whether the parameter is IN, OUT, or IN OUT. A USING clause in EXECUTE IMMEDIATE supports passing parameters to embedded SPL blocks. The NVL function now accepts double-precision data type arguments.ĮDB Postgres Advanced Server now skips IN/OUT/IN OUT modifiers in the USING expression. This enhancement allows you to assign a SELECT list having a mix of scalar and composite type values that are fetched from a table to corresponding scalar or composite variables (including collection variables) in the SPL code. The INTO clause now accepts multiple composite-row type targets in SPL.

It also allows you to add to or modify the list as needed.Īdded support for WHERE clause to the UPDATE and INSERT of MERGE command for Oracle compatibility.Īdded the HTP and HTF packages to built-in packages for Oracle compatibility. This enhancement adds the infrastructure to the configuration file in which you can define the list of operators and functions that can push down to the remote server. See Obfuscating the LDAP password.Īdded OCI dblink configuration file approach to restrict pushdowns. You can supply a module that transforms the ldapbindpasswd value in the pg_hba.conf file before the value is passed to the LDAP server.

See TDE docs for more information.ĮDB Postgres Advanced Server now allows non-superusers to load data using EDB*Loader.Įnabled multi-insert support for the dynamic partition for EDB*Loader and COPY command.ĮDB Postgres Advanced Server now lets you obfuscate the LDAP password in the pg_hba.conf file. User data includes the actual data stored in tables and other objects, as well as system catalog data such as the names of objects. This encryption is transparent to the user. Transparent Data Encryption (TDE) encrypts any user data stored in the database system. See the PostgreSQL 15 Release Notes for more information.

Download Optimizer 15.2