Change Log: 1.6.4

General

The Help Contents has been completely updated.

Support for SSL connnections implemented. See Figure 1.

Saving edits to procedures and views caused the following procedure or view node to be selected. This is now fixed.

Undo didn't work for zone edits. This is now fixed.

Saving a database design produced an error if procedures or views did not have any code defined. This is now fixed.

Rename History produced errors if a rename was undone and redone several times. This is now fixed.

Removing or adding diagram objects didn't always display the 'modified' asterisk in the status bar. Now it does.

A bug in Foreign Key Edit panel sometimes only listed one table in the Parent Table combo box is now fixed.

Figure 1. SSL Support.

General GUI

On Add Column and Column Templates panels, the text field for length and scale didn't render properly on some operating systems and certain look and feels. This is now fixed.

Added new Database and Diagram menus to centrally locate common actions. These actions now also have new short cut keys assigned to them. See Figure 2.

Figure 2. New Database and Diagram Menus.

Diagrams

Can now cut/copy/paste diagram objects to other diagrams.

A zoom toolbar has now been implemented showing the zoom level of the current diagram. See Figure 3.

Adding a table to a diagram where the zoom wasn't 100% resulted in the table being placed at an incorrect location. This is now fixed.

Diagram zooming now maintains the image center while zooming.

Diagram Export menus didn't always refresh when a different database was opened or when new diagrams were added. This is now fixed.

Figure 2. Cut/Copy/Paste Diagram Entities.

Reverse Engineering

Postgresql entites starting with pg weren't always being reverse engineered. This is now fixed

Reverse Engineer of views failed if the view's code contained multiple FROM clauses. This is now fixed.

Minor capitalization inconsistancies in the Reverse Engineer Log have been fixed.

Forward Engineering

Support for NULL length and NULL scale values for PostgreSQL data types is now implemented

PostgreSQL data types BIT and BIT VARYING weren't forward engineering properly. This is now fixed.

Support for UUID data type in PostgreSQL has now been added

Objects that have been unselected by users in Preferences | Forward Engineer to be ignored during Forward Engineer script calculation will also now be ignored in database comparisons in Reverse Synchronize.

Script Hierarchy Explorer is now cleared when a new database design is opened.

Carriage returns are now added to some DDL statements in the generated scripts that were significantly and consistantly longer than 80 characters.

Table Data Viewer

On the dynamically generated data edit panels the combo boxes for fields with foreign keys weren't always available when they could have been. This is now fixed

Cache containing database data for a table is deleted when the table is deleted from the database design.

Inserting or updating values containing apostrophes sometimes caused errors. This is now fixed.

SQL Editors

Database Documentation

The database documentation panel has been renamed to Document DB.