Red Hat Database 2.1 Release Notes
==================================

Copyright (c) 2001, 2002 Red Hat, Inc.

This document details the features that are new to Red Hat Database 2.1.

Note: Red Hat recommends that you update your Red Hat Linux Advanced
Server 2.1, Red Hat Linux 7.3 or Red Hat Linux 8.0 environment to the latest
errata. There have been a number of issues addressed that could affect the 
operation of Red Hat Database.

1. Migration

   No data migration is necessary if updating a Red Hat Database 2.0
   installation to Red Hat Database 2.1.  However, we strongly recommend
   users backup their databases before upgrading to Red Hat Database 2.1. 

   A dump / restore is required to migrate data from Red Hat Database for
   Red Hat Linux 7.1.x to Red Hat Database 2.0/2.1.

2. Enhancements and Changes Included in Red Hat Database 2.1

   . Red Hat Database now installs on Red Hat Linux 8.0

   . Red Hat Database is now powered by the latest stable community version
     of PostgreSQL, 7.2.3, plus specific enhancements back ported from
     PostgreSQL 7.3. 
 
     Changes from PostgreSQL 7.2.2 to PostgreSQL 7.2.3 include, but are not
     limited to:

       . security fixes
       . prevention of possible compressed transaction log loss
       . prevention of non-superuser from increasing most recent vacuum
         information
       . correct handling of pre-1970 date values in newer versions of glibc
     
     PostgreSQL 7.3 back port enhancements include, but are not limited to:

       . pg_dump enhancements to BLOB support and ALTER TABLE PRIMARY KEY
       . psql enhancements to show rules when describing a view, tab
         completion offering view names as well as table names, and
         correction of parenthesis state after \g or \r commands
       . vacuum enhancements
       . ODBC installation installs header files

   . Red Hat Database contains the latest stable version of RHDB
     Administrator, 1.1, which includes many functional and robustness 
     enhancements.

     RHDB Administrator 1.1 functional enhancements include, but are not
     limited to:

       . associated triggers are now displayed in the Trigger View for
         RI triggers that are part of a constraint
       . logging of SQL data in the "SQL Log Window" is now optional and
         can be toggled via the "Log SQL Data" option under the "View"
         menu
       . Operator View now lists the procedure/function that implements
         the operator 
       . the keyboard Home key moves the selector to the parent cluster of
         the currently selected node and the keyboard End key moves the
         selector to the last open node under the current cluster

     RHDB Administrator 1.1 robustness enhancements include, but are not
     limited to:

       . absolute paths are no longer required when importing/exporting
         files
       . the handler location can be manually typed in when creating a 
         language
       . the "[add|remove] column" button inconsistencies in the vacuum
         analyze dialogs have been removed
       . focus/selection visibility issues in the Create and Alter dialogs
         have been fixed
       . tabbing order on dialogs is now consistent
       . Left Tree view pane no longer scrolls to the top when a hyperlink
         is selected
       . progress icon correctly identifies the current state of the tool
       . various combobox modifications across the tool 
       . detailed view for operators, where the associated commutator / 
         negator was deleted, is raised correctly
       . view cells that contain data too long to be displayed within
         the current window dimensions will now contain individual cell
         scrollbars to facilitate scrolling through the data
       . correct string used when a data type is created with PASSEDBYVALUE
       . functions created using catalog data types will display the proper
         type
     

   . Red Hat Database contains the latest stable version of Visual Explain,
     1.1, which includes many functional and robustness enhancements.
       
     Visual Explain 1.1 functional enhancements include, but are not limited
     to:
     
       . Visual Explain is now responsive while an explain operation is 
         running on the server.
       . the root node, which contains the total cost and elapsed time, is 
         automatically selected when the explain operation completes
       . an "Explain Analyze" menu item has been added to the "Statement"
         menu and the "Explain" button is now configurable between Explain
         and Explain Analyze
         
     Visual Explain robustness enhancements include, but are not limited to:

       . text no longer overlaps in the Tree View
       . stack trace eliminated when selecting recently used files from
         the "File" menu
       . more consistent password handling     

3. Documentation

   The Red Hat Database 2.1 manuals are included in HTML and PDF formats.
   The manuals included are:
   . Red Hat Database Administrator and User's Guide
   . Red Hat Database Getting Started / Installation Guide
   . Red Hat Database Graphical Tools Guide
   . Red Hat Database Programmer's Guide
   . Red Hat Database SQL Guide and Reference

   Red Hat Database documentation can also be found on-line at
   http://www.redhat.com/docs/manuals/database.  Additional Red Hat
   Database information, such as How-Tos and whitepapers, are located at
   http://www.redhat.com/support/resources/howto/database.html.

4. Red Hat Database Project

   A community project site has been created for the Red Hat Database
   Project.  This site, found at http://sources.redhat.com/rhdb, contains
   documentation, mailing lists, projects and utilities specific to Red
   Hat Database.