Thread: pgAdmin 1.4.0 Released
I'm pleased to announce the release of pgAdmin II v1.4.0. Many thanks to all those that have contributed time and effort to it's development and testing. pgAdmin II is a comprehensive PostgreSQL management and administration tool for Microsoft Windows platforms. For more information and downloads, please visit the website at http://www.pgadmin.org/ (kindly hosted by hub.org). This release is the first stable release to support the upcoming version 7.3 of PostgreSQL. Users of pgAdmin II v1.2.0 *must* upgrade if they wish to use PostgreSQL 7.3. Changes made since version 1.2.0 are listed below. Regards, Dave. 1.4.0 ----- Don't shutdown on error when incorrectly setting a column default. Don't get hung up on errors in the comment cache. Reference OID columns as rs.Fields("oid") not rs!oid to get around an MDAC/case mangling bug in some locales. Allow the use of numeric only usernames. Updated PostgreSQL docs to 7.3rc1. 1.3.82 ------ Attempt to capture all errors, not just the last. 1.3.76 ------ 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. 1.3.60 ------ 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. 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+. Changes to the Migration Wizard =============================== 1.4.0 ----- Quote sequence names in the Migration Wizard. Refix the Foxpro memo problem from 1.3.60. 1.3.82 ------ Allow the use of numeric identifiers. 1.3.76 ------ 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. 1.3.60 ------ 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]
Dave Page wrote:
> I'm pleased to announce the release of pgAdmin II v1.4.0. Many thanks
> to all those that have contributed time and effort to it's
> development and testing.
>
> pgAdmin II is a comprehensive PostgreSQL management and administration
> tool for Microsoft Windows platforms. For more information and
> downloads, please visit the website at http://www.pgadmin.org/
> (kindly hosted by hub.org).
>
I seem to be having DNS troubles could some one give me an IP address :)
Thanks,
- Stuart
-----Original Message-----
From: Henshall, Stuart - Design & Print [mailto:SHenshall@westcountry-design-print.co.uk]
Sent: 20 November 2002 16:05
To: pgadmin-support@postgresql.org
Subject: Re: [pgadmin-support] pgAdmin 1.4.0 ReleasedDave Page wrote:
> I'm pleased to announce the release of pgAdmin II v1.4.0. Many thanks
> to all those that have contributed time and effort to it's
> development and testing.
>
> pgAdmin II is a comprehensive PostgreSQL management and administration
> tool for Microsoft Windows platforms. For more information and
> downloads, please visit the website at http://www.pgadmin.org/
> (kindly hosted by hub.org).
>
I seem to be having DNS troubles could some one give me an IP address :)
Thanks,
- Stuart