The pgAdmin Development Team are pleased to announce the release of pgAdmin 1.8.1, 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.1 is primarily a bug fix release, including the following changes:

- Fix a bug that could cause a crash on GTK when closing the query tool
  in certain circumstances.
- Avoid a crash if the connection is lost and the Functions node is
  refreshed.
- Avoid crashes when working with objects with % characters in the
  name.
- Properly reverse-engineer the SQL for indexes with DESC, NULLS FIRST
  or NULLS LAST column options.
- Only offer the Jobs node if the user can access the pgagent schema.
- Ensure the 'Create Rule' context menu option is always offered when
  appropriate.
- Prevent the user from trying to debug catalog objects.
- Refresh the tree without erroring after creating a new package on
  EnterpriseDB.
- Fix a crash that occured if an object called '%' was selected in the
  treeview, per Alexander Steffens.
- Fix a line number error in the debugger seen with procedures which
  start on the same line as the 'CREATE PROCEDURE foo IS ...' Per report
  from Heikki Linnakangas.
- Cleanup the covering index control logic in the Foreign Key dialogue.
- Fix to refresh version string and number, and last OID, per a report
  from Alexander Kirpa.
- Disable CREATE FUNCTION etc. under EnterpriseDB packages because they
  are created as part of the main package body.
- Fix some broken references to online help pages.
- Don't offer 'Drop Cascaded' unless the user can 'Drop' the object.
- Prevent non-superusers from attempting to use the debugger because the
  plugin API won't let them anyway.
- Check that functions exist before debugging or setting global
  breakpoints on them. Remove them from the treeview if not.
- Correct the URL for the EDB public synonym help page
- Handle the corner case when a user includes quotes in an object name
  (backport of 2007-10-26 fix applied to trunk)
- Fix the debugger's connection class to ensure database names requiring
  quotes will work and that is can be used with SSL and Kerberos
  connections.
- Allow the length of array-typed columns to be changed (eg. 'character
  varying[](100)'), per report from Ferenc Lutischan
- Don't allow the user to direct-debug trigger functions, only global
  breakpoints should be used on them (or the trigger itself).
- Don't offer edbspl functions when creating triggers as they should
  have inline bodies.
- Don't quote database names that happen to be keywords when starting
  the debugger.
- Don't offer package names and system schemas as schemas when creating
  public synonyms.
- Fix pgAgent's job query when a host agent is specified so that jobs
  don't execute every time round the loop regardless of schedule, per
  Brian Kalbfus.
- Add EnterpriseDB's default database (edb) to the Server dialog's
  default option.
- Don't allow the user to debug an EnterpriseDB package function or
  procedure if the body isn't defined.
- Don't offer the user the chance to create new columns on system
  catalogues.
- Fix the debugger to send actual NULL values rather than 'NULL' through
  the EnterpriseDB callable statement API. Allow parameter values to be
  NULL or empty strings on both PostgreSQL and EnterpriseDB using the
  same syntax as the Edit Grid.
- Always open the PostgreSQL Help when selecting that menu option, even
  if connected to EnterpriseDB.
- Fix EnterpriseDB public synonym loading so that they aren't considered
  system objects.
- Fix path discovery on Unix so standard installs can be relocated
  easily.
- Fix character number display in the query tool.
- Use popen() when testing the versions of helper apps on non-windows
  platforms to avoid an obscure bug on PPC Macs that could leave
  wxExecute hanging indefinitely whilst waiting on a zombie process.
- When creating a new index and specifying both tablespace and fill
  factor, make sure the SQL is formulated correctly, per Stefan Wolf
- Fix the locks tab on the server status dialogue so it works correctly
  with PostgreSQL 8.3+.
- Properly format the object comments shown in the properties list when
  a collection node is selected. Per report from Mike Blackwell.
- Fix a bug preventing the 'on error' flag of a pgAgent job step being
  edited, per Jon Roberts.
- Properly escape _'s in queries for schemas, per Derek Fonda.
- Don't try to enable/disable prepared transaction related controls on
  pre-8.1 servers, per Karl Zellnig

--
Dave Page
pgAdmin Project Lead

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

              http://archives.postgresql.org

Reply via email to