pgAdmin v7.1.0 Released - Mailing list pgsql-interfaces

I am pleased to announce the release of pgAdmin v7.1.0 at
www.greatbridge.org/project/pgadmin/

pgAdmin is a PostgreSQL database design/admin tool for Windows
95/98/ME/NT/2K. This version has been developed for use with PostgreSQL
7.0.X and PostgreSQL 7.1.X

New features/bug fixes include:

Key to contributors:

DP - Dave Page
RC - Rod Childers

(RC) Added 'Migrate Primary Keys' code to the Migration Wizard.
(DP) Fixed a bug where system comments were migrated from pg_description    as well as user comments.
(DP) System generated Referential Integrity (foreign key) triggers are now    hidden from the Trigger Browser unless
'ShowSystem Triggers' is
 
checked.
(DP) Foreign Keys, Primary Keys, Check Constraints and Unique Constraints    are now listed in the Table Browser
alongsidethe table columns.
 
(DP) Allow viewing of the ACL on Sequences and Views
(DP) Allow Views to be selected in the Privileges Dialogue.
(RC) Changed default datatype for VarChar and VarWChar to the PostgreSQL    varchar type in the Type Map used by the
MigrationWizard.
 
(DP) Added code to auto upgrade Server Side Objects (SSO's) if they have    been updated.
(DP) Grant All permissions to Public on pgadmin_* views so all users can    use them.
(RC) Foreign Keys can now be migrated in the Migration Wizard.
(DP) Fixed a bug in the scrolling log window which caused a blank line to    be shown at the bottom.
(DP) Fixed a bug in the Table and Index browsers that could make the info    frames appear to flash as objects were
selectedin the treeview.
 
(DP) Added options to the Database browser to create User and System DSNs    for the selected database.
(RC) Fixed a bug which could caused indexes to be duplicated or created    for non-existent tables in the Migration
Wizard.
(DP) Rebuilt libpq.dll & psql.exe from the 7.1 source. Used /MD linker    flag to prevent psql.exe from dying
horriblywhen redisplaying the
 
prompt    after a <CR>.
(RC) Fixed a bug where the Migration Wizard would fail if a Date/Time    field in Access was being migrated to a Date
columnin PostgreSQL and
 
only a    time was present. This occurs because Access uses Date/Time fields for
dates    and/*or* times.
(DP) Assume all pg_* objects are System Object regardless of their OID.    This primarily hides Toast related objects
butshould also hide other
 
future    system objects (assuming the PostgreSQL team continue using a pg_
prefix).
(DP) Fixed a bug preventing changes to the Type Map settings being    reloaded from the registry on Windows 95.
(DP) Added Outer Join support to the SQL wizard.
(RC) Allow the Migration Wizard to return to step 1 after Migration has    competed.
(DP) Removed the DataGrid which would not update data in tables with    uppercase characters in column names (caused by
ADO).The new Grid is
 
based    on the original code but is integrated directly into pgAdmin, and does
query    based updates as required whilst maintaining the correct data in the
grid    without refreshing a recordset. Unlike ADO, this code will allow you to
drop    or update multiple rows if the selected row cannot be uniquely    identified. Queries used to select data are
parsedto determine whether
 
the    data can updated and options are given accordingly.
(DP) Updated to check for views with pg_class.relkind = 'v'.
(DP) Prevented the Migration Wizard from Migrating varchar fields of    excessive size (8088).
(DP) Fixed a bug in the CREATE TABLE dialogue which prevented re-adding a    serial column if one was deleted, or if a
CREATETABLE operation with a    serial column was aborted.
 
(DP) Added code to ensure that only superusers can create or drop Server    Side Objects.

Regards, Dave.