pgAdmin v7.1.0 Released

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 'Show System Triggers' is
checked.
(DP) Foreign Keys, Primary Keys, Check Constraints and Unique Constraints
are now listed in the Table Browser alongside the 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 Migration Wizard.
(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 selected in 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 horribly when 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 column in 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 but should 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 parsed to 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 CREATE TABLE operation with a
serial column was aborted.
(DP) Added code to ensure that only superusers can create or drop Server
Side Objects.

Regards, Dave.