pgAdmin 1.5.60 (BETA) Released

I'm pleased to announce the release of pgAdmin II 1.5.60, the first beta version of the upcoming 1.6 release.

pgAdmin II is a freely available PostgreSQL management tool written in Visual Basic for Windows platforms (*nix users please see the note at the end of this message). The website is http://www.pgadmin.org/, and the software may be downloaded from http://www.pgadmin.org/downloads/.

Support for pgAdmin is provided through the pgadmin-support(at)postgreslq(dot)org mailing list. Joining instructions are on the website.

The vast majority of updates and new features in this release are the result of hard work by Frank Lupo, to whom I'd like to express my thanks for his commitment and effort.

Changes/updates in this release
===============================

- Refresh comment cache after editting views.
- Decode trigger procedure parameters correctly.
- Fixed a bug in Domain counting code.
- Fixed a bug in the Foreign Key analysis code that occured with multiple foreign keys to the same table.
- Added combo box of available variables to frmDatabase/frmUser [Frank Lupo].
- Added 'Show current settings' option for frmDatabase [Frank Lupo].
- Quote database & user variable values correctly.
- Fix ADO crash when accessing binary columns in the data grid.
- Added support for Casts [Frank Lupo].
- Added 'Find Object' [Frank Lupo].
- Autosize listview columns [Frank Lupo].
- New custom error dialogue [Frank Lupo].
- Added MS Access Exporter [Frank Lupo].
- Added a pg_hba.conf editor plugin [Frank Lupo, Mark Yeatman].
- Additional User/Database variable handling code including combo boxes for known options [Frank Lupo].
- Added an option to reset statistics [Frank Lupo].
- User definable row limit when viewing large tables/rows [Frank Lupo].
- Added command history to the SQL dialogue [Frank Lupo].
- Allow F5 to execute SQL queries.
- Limit statistics to the correct schema [Frank Lupo].
- Allow numeric usernames in groups.
- Added a dialogue to allow column definition to be copied from another table in Create Table dialogue [Frank Lupo].
- Allow scroll through objects in property dialogues [Frank Lupo].
- Added Copy/Paste options for most object types [Frank Lupo].
- Added support for Conversions [Frank Lupo].
- Added support for rules on views [Frank Lupo].
- Added support for dependency checking [Frank Lupo].
- Fixed date handling in the Excel exporter.
- Added support for Set Returning Functions [Frank Lupo].
- Allow addition and removal of Foreign Keys post table creation [Frank Lupo].
- Allow modification of column storage type [Frank Lupo].
- Allow specification of array dimensions on new columns [Frank Lupo].
- Updated PostgreSQL docs to 7.3.2.

Available as a seperate download is the pgAdmin Migration Wizard. The Migration Wizard is designed to help move databases from other DBMSs into PostgreSQL, and is released under the GNU General Public Licence.

Changes/updates in this release
===============================

Create objects in the correct schema.
Allow long FKey names in PostgreSQL 7.3+
Added option for per-table commits [John Wells]
Allow migration of serial columns from SQL Server < 7.0 [Brage Førland]
Fix bug in NOT NULL column discovery [Brage Førland]
Copy migrate serial columns datatype according to the type map [Brage Førland]
Create sequence with a _seq suffix as per PostgreSQL
Don't error with Access 1:1 Foreign Keys.
Format dates correctly for PostgreSQL in some regional settings.

Note to *nix users
==================

pgAdmin III is nearing beta quality now, and is being written in C++ with the wxWindows cross platform GUI framework to enable it to run on *nix platforms as well as Windows. Binary snapshot builds can be downloaded from http://snake.pgadmin.org/ for Linux and Windows, and the source can be found at http://cvs.pgadmin.org for compilation on other platforms.

Note that pgAdmin III is alpha quality software. Use it at your own risk!!

Regards, Dave.