pgAdmin 1.3.76

I'm pleased to announce the release of pgAdmin II 1.3.76. This is the
second release from the 1.3 development code.

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@postgresql.org.

Changes in this release include:

- Fixed a bug that attempted to access inaccessible databases when
clicked on in the treeview.
- Use doubles instead of longs to cope with very large OIDs.
- Fixed a bug that caused an error if the pgAdmin window was too small
when the listview was populated.
- Don't class 'public' as a system schema.
- Don't throw an error when changing Not Null/Primary Key on a new
column in an existing table.
- Don't allow (attempted) alteration of certain column attributes in
PostgreSQL 7.2.
- Fixed some errors in the function editor.
- Raise errors properly from pgSchema.
- Only quote identifiers in datagrid update queries when required.
- Allow use of numeric identifiers.
- Fixed a bug that prevented renaming columns.
- Fixed an error that occured when clicking on the Relationships node
under a Foreign Key.
- Fixed a bug that prevented updating of Sequence values.
- Display object counts in the treeview immediately now we know them in
advance.
- Handle dates/time formats supported by Windows, not just those
supported by PostgreSQL (particuarly those that use . seperators)
- Allow use of F5 to execute SQL queries (Andy Kelk).
- If SQL is highlighted in the SQL textbox, execute only that, not the
whole query (Andy Kelk).
- Fixed a bug where an SQL file got overwritten if the user clicked
'Cancel'.
- Added DROP COLUMN support (Wahoo!).
- Don't display ON UPDATE/ON DELETE clauses in Foreign Keys if
unspecified.
- Fixed broken error handling in pgSchema.

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

- Correctly clear CREATE SEQUENCE sql. [John McCawley]
- Check the Migration type in a more sensible way. [John McCawley]
- Insert empty values correctly to avoid errors by not inserting into
NOT NULL columns.

Regards, Dave.