EnterpriseDB TECHNICAL ALERT Postgres Plus Advanced Server July 28, 2009 EDB*Plus

A Technical Alert has been published and made available to all customers who have purchased a Subscription plan to Postgres Plus
Advanced Server.

The Technical Alert archive file containing a description of the alert and updated software is available at: http://www.enterprisedb.com/downloads/updates/EDBPlusUpdate_Build_19-20090723.zip

Customers using the Advanced Server DBA Management Server will be notified automatically and also receive a Technical Alert email from EnterpriseDB shortly.

TECHNICAL ALERT STATUS
========================

Status: Recommended

Critical - this update fixes a possible data corruption, calculation, search set, or other function that may lead to inaccurate results. The update should be applied at the earliest possible time as it may affect a large number of users.

Recommended - this update fixes non-critical issues that may impede general usage and require undesirable work-arounds affecting a limited number of users. The update is recommended to be applied when convenient.

Informational - this update is informational only for non-critical issues. No software update or patch needs to be applied and issues may be addressed in the field using the specified version currently installed.

WHAT IS IN THIS ALERT
=====================

This Technical Alert is notifying you of a software update that addresses the EDB*Plus module shipped with the GA version of Postgres Plus Advanced Server 8.3 R2 (8.3.0.106).

The software update contains the following fixes and enhancements:

1) Support for executing obfuscated scripts (12197)

Symptom: If a SQL script is obfuscated using EDB*Wrap, the resulting .plb file could not be executed using EDB*Plus.
Fix: EDB*Plus is enhanced to support execution of wrapped scripts.
New Behavior: EDB*Plus can execute .plb files containing obfuscated SQL scripts.
Limitations: Result sets & row counts will not be displayed for DDL & DML statements respectively. This limitation exists because the JDBC driver uses Extended Query Protocol, which in turn does not support wrapped scripts on the server end.

2) SQL statements rolled back even if edb_stmt_level_tx GUC is set to ON (9116)

Symptom: If edb_stmt_level_tx is ON, an aborted SQL statement should not trigger a rollback for previous SQL statements. This wasn't working properly in EDB*Plus.
Fix: EDB*PLus has been enhanced to determine if the transaction really needs to be rolled back based on the value of edb_stmt_level_tx GUC.
New Behavior: If the value of edb_stmt_level_tx GUC variable is ON, previous SQL statements are not rolled back if a subsequent statement aborts.

3) Column data gets truncated if it exceeds 50 characters (12092)

Symptom: For columns with data type TEXT with unknown length, data after 50 characters was truncated. A workaround was to set the column preferences using the COLUMN command.
Fix: Text wrapping is now turned on at 50 characters for columns with TEXT data type whose length can not be determined.
New Behavior: If the text exceeds 50 characters, characters 51 and beyond will continue on the next line.

4) Database server messages are displayed as '???' on Simplified Chinese locale (12406)

Symptom: In cases where the default encoding is overriden during installation to Simplified Chinese, the db server messages are displayed as "???".
Fix: JDBC always used to connect using CLIENT_ENCODING=UTF8. Now the GUC variables CLIENT_ENCODING & SERVER_ENCODING are also passed to JDBC allowing it to make an encoding change. As a pre-requisite, please perform the following steps to get your desired messages in the proper language:
a) Add the following setting at the start of the launcher script (edbplus.sh for Linux & edbplus.bat for Windows):
set EDB_MSGENCODING=CP1252
b) When connected, change your encoding to EUC_CN with the following command:
alter session set client_encoding=EUC_CN"
New Behavior: All messages are displayed correctly for encoding & locale specified by the user.

This update only replaces the EDB*Plus jar file (Build 19). The core engine version remains 8.3.0.106.

IS THIS ALERT FOR ME?
====================
This alert is for customers using:

- Postgres Plus Advanced Server version: 8.3.0.106
- EDB*Plus

HOW TO GET THE UPDATE
======================

This update is available through the Postgres Plus Advanced Server DBA Management Server. Click either the 'Check for Updates' link or the Elephant icon which should be colored Yellow indicating an update is available.

If you don't use the DBA Management Server, you may optionally download the update at the following URL:

http://www.enterprisedb.com/downloads/updates/EDBPlusUpdate_Build_19-20090723.zip

HOW TO APPLY THE UPDATE
========================

Please perform the following steps in order to update your installation with the latest version of EDB*Plus:

1) Unzip the file update_edbplus_20090723.zip and copy it to the $EDB_HOME/updates directory

2) Run the script edb_update.sh/edb_update.bat from the update_edbplus_20090723 directory

HOW TO RESTORE OLD VERSION
===========================

Please perform the following steps in order to restore your installation to the old version of EDB*Plus:

1) Unzip the file $EDB_HOME/updates/update_edbplus_20090723_restore.zip and copy it to the $EDB_HOME/updates directory

2) Run the script edb_restore.sh/edb_restore.bat from the update_edbplus_20090723_restore directory

TROUBLESHOOTING
=================

If you experience any problems applying the upgrade or restoring the old version after applying the upgrade, please contact Technical Support at:

Email: support@enterprisedb.com
Phone: +1-732-331-1320 or 1-800-235-5891 (US Only)
Submit a Support ticket at: https://www.enterprisedb.com/myenterprisedb.do