The latest version of PostgreSQL's GUI tool, pgAdmin III has been released following a year of development. Running on Windows, Linux and FreeBSD it supports new features to be introduced in the coming PostgreSQL 8.0 release.
Users of some client software designed to support PostgreSQL 8.0, which is currently in late beta, are occasionally reporting errors along the lines of:
column n.nsptablespace does not exist
This is a result of a last-minute change to the system catalogues, which has not yet been incorporated into the latest releases of some client applications such as phpPgAdmin and EMS PostgreSQL-Manager.
One more, probably the final beta version has just been released, containing a lot of minor fixes. One extreme case with tables containing more than 65535 columns causing crashes has been fixed. In the Windows version the default external editor in psql is now NOTEPAD.EXE. The changelog from Beta 4 is at ftp://ftp.postgresql.org/pub/source/v8.0.0beta/ChangeLog-Beta4-to-Beta5.
This beta requires an initdb.
Among the many "headline" features scheduled for the upcoming PostgreSQL 8.0 release, such as the Windows version, there is a whole bunch of less glamourous additions which might not blow the PHB's mind, but make life that little bit easier for the humble DBA / developer. Some of these involve PostgreSQL's SERIAL type.
The latest version of phpPgAdmin - PostgreSQL's equivalent of phpMyAdmin - now includes support for the soon-to-be-released PostgreSQL 8.0. New features supported include tablespaces, named function arguments and enhanced ALTER / ADD column syntax. Other enhancements include a context-sensitive online help system and syntax highlighting for PL/SQL, PL/PgSQL, PL/PHP, PL/Ruby, PL/Java, PL/J, PL/Python and PL/Perl functions.