pgAdmin III v1.8.4 released

The pgAdmin Development Team are pleased to announce the release of pgAdmin 1.8.3, the Open Source graphical PostgreSQL administration tool for Windows, Linux, FreeBSD, Mac OS X and Solaris, now available for download in source and a variety of binary formats from:

http://www.pgadmin.org/download/

v1.8.4 is primarily a bug fix release, including the following changes. Note that v1.8.3 was never announced as a release due to an issue found at the last minute.

v1.8.4 fixes:

• Fix potential crash bug in the query tool logging code, per Erwin.

v1.8.3 fixes:

• Allow a debugging session to be cancelled correctly on windows.
• Fix a corner case in which closing the debugger window following a failed attempt to create a global breakpoint (for example, because of an existing breakpoint) could cause a crash on Windows.
• Store pgAgent job step result codes in an int4 column. int2 was proving too small in some cases resulting in an error.
• Allow EnterpriseDB packages to be created without bodies.
• Always refresh the data when the user clicks OK on the edit grid options dialogue to ensure the filter/sort is applied to current data.
• Prevent unsaved changes in the edit grid being lost if the filter or sorting dialogue is opened.
• Update node text when refreshing treeview nodes in case part of the identifier has changed.
• Correct config window help paths.
• Don't load group roles and old-style groups on the security tab on 8.1 and higher.
• Correctly quote role names when reverse engineering ACLs.
• Don't allow the user to attempt to remove columns from an existing index or index constraint.
• Disable the RULE privilege on 8.2+ for views per Erwin.
• Fix the logging system to ensure that errors from the query tool get logged, and notices are only output once.
• Cleanup some other minor misbehaviours at the same time. Per report from Erwin.
• Ignore the type modifier for domains in function signatures.
• If stopping the server service fails after stopping dependent services, wait 5 seconds and try again up to 10 times to allow the dependents time to shutdown fully.
• Don't include the -h option when calling pg_dump or pg_restore if there is no hostname to specify.
• Convert setting names to lower case so we don't end up with DateStyle and datestyle for example.
• Construct SQL used to add columns such that the entire operation happens in one statement to ensure default values and NOT NULL can be set together. Per report from Laurent ROCHE.
• Properly quote the maintenance database name when creating a new connection.
• Show the schema correctly for EDB public synonyms that point to other synonyms.
• Remove long-dead Explain Text option from the Query Tool.
• Properly quote synonym names when refreshing.
• Parse function parameter names correctly when they contain commas.
• FOSDEM fix: Include overriding columns in reverse engineered SQL for child tables, rather than commenting them out and marking as inherited.
• Avoid quoting 'text' when used as a type name per Erwin.
• Correctly generate table DDL when inherited columns follow the last 'real' column, per Peter Gagarinov.
• Hide array variants of table-types in datatype selectors where we already hide the table type itself.
• Fix query that tries to apply the schema restriction.
• Specify the length correctly when creating columns of 'time with time zone' and friends.
• Allow non-superusers to debug their own functions.
• Fix query that tries to apply the DB restriction.
• Ensure info passed to Guru hints is HTML-safe.

Dave Page

pgAdmin Project Lead

This post has been migrated from a previous version of the PostgreSQL website. We apologise for any formatting issues caused by the migration.