pgAdmin II v1.3.60

I'm pleased to announce the release of pgAdmin II 1.3.60. This is the
first release from the 1.3 development code and should be considered
Alpha quality.

pgAdmin II is an open source PostgreSQL database design and management
tool for Windows platforms. Further information and downloads can be
found at http://www.pgadmin.org/.

This release includes extensive changes to support schemas in the
upcoming 7.3 release of PostgreSQL. Testing on both current and
development versions of PostgreSQL is encouraged - any bug reports
should be sent to the support mailing list:
pgadmin-support(at)postgresql(dot)org(dot)

Changes in this release include:

- New resize code in frmMain - allows adjustment of the
Listview/Definition pane split.
- Fixed a bug where selecting privilege ALL did not disable the Rule
privilege.
- Hide System Objects in the SQL Wizard.
- Updated icons.
- Added Refresh button to DataGrid.
- Added Select All/Select None buttons to potentially large listviews.
- Simplified Listview handling code.
- Reworded text on encrypted passwords in frmOptions.
- Added Query Log Recorder.
- Fixed a bug that cleared default values instead of updating them.
- Check the PostgreSQL version when connecting and handle correctly.
- Updated the PostgreSQL docs to the 7.2 Release version.
- Clear Upgrade Wizard listview before populating.
- REVOKE privileges from groups correctly.
- Allow creation of tables with no columns, just inherits.
- Don't include inherited columns & checks in table definitions.
- Fixed a bug in the Import Wizard data parser.
- Fix mouse pointer and allow display of errors when timer is stopped
(Mark A. Taff).
- Fixed a bug in the query parser in the SQL output grid.
- Allow pseudo modification of views with PostgreSQL 7.2+
- Views can now be renamed.
- Fixed a bug in the trigger reverse engineering that prepended the
execution conditions of previous triggers to the current.
- Added an option to enable or disable Auto Row Counts.
- Added Rows property to View objects.
- Set default database encoding to "SQL_ASCII".
- Quote function definition when needed.
- Fixed a bug that prepended a carriage return when loading SQL queries
from file.
- Added AllowConnections property to database objects, display it in
pgAdmin, and check it before attempting to connect to a database.
- Invalidate Caches before refreshing hierarchy in pgSchema.
- Standardised db name access method throughout pgSchema's classes, and
added caching.
- Added support for renaming Sequences & Indexes.
- Committing a table now also commits sub objects.
- Added a '-wine' command line option to disable modal dialogues (they
don't seem to work under Wine).
- Prevent connection to databases until they are selected. Added an
option to revert to old behaviour.
- Added support for dropping checks with PostgreSQL 7.2+.
- Excel Exporter: Format the cell for the data type & inserts the data
using the cells 'FormulaR1C1' property (David Horwitz).
- Allow selection of font for display of data.
- Added a guide to setting up a development environment.
- Added a HOWTO on using MD5 Encrypted Passwords.
- Added support for viewing statistics on PostgreSQL 7.2+
- Cancelling closure of child windows will now cancel application exit.
- Allow sorting of listview/statsview by clicking the column headers.
- Use Primary Keys for updating/deleting rows in the data editor where
possible.
- Fix EXPLAIN for PostgreSQL 7.3+
- Added support for Domains in PostgreSQL 7.3+
- Enhanced the query parser to detect queries with functions and
subselects in the column list, and aliased columns as non-updateable.
- Quote sequence names properly when using setval.
- Treat all objects named pgadmin_* as system objects.
- Fixed a bug in the Operator Cache which also cached the left & right
types.
- Allow addition & removal of NOT NULL constraints on columns with
PostgreSQL 7.3+.
- Check the ODBC driver version correctly for EXPLAIN.
- Added support for Schemas in PostgreSQL 7.3+.
- Removed Revision Control due to it's complexity and lack of use
following an RFD on the hackers and support lists.
- Rewrote the code that associates treeview nodes with pgSchema objects.
The new code is faster and more reliable.
- Correctly recognise functions with one opaque argument.
- Filter functions listed when creating Types & Operators to only those
that are suitable.
- Only quote identifiers when required.
- Allow addition and removal of Primary Keys with PostgreSQL 7.3+.
- Allow renaming of Triggers in PostgreSQL 7.3+
- Added support for configuration of user & database config variables
with PostgreSQL 7.3+
- Added support for Array datatypes.
- Added support for ACLs on Databases, Languages & functions with
PostgreSQL 7.3+.
- Allow display & updating of column statistics values with PostgreSQL
7.2+.
- Allow use of language validators with PostgreSQL 7.3+.

The Migration Wizard (distributed seperately under GPL) has also been
updated:

- Updated for PostgreSQL 7.3 Support.
- Copy column values into a temp variable before use to avoid problems
with the Foxpro driver.
- Don't clear source table list when navigating back past the tab.
- Added pre-requisites list to README.txt.
- Added an option to the wizard to "Drop any existing destination
tables" [John McCawley]
- Added support for migration of auto number fields from SQL Server.
[John McCawley]

Regards, Dave.