Ever start a transaction in psql, then lose track of whether it's been committed or not? psql provides a prompt formatting option (%x) which displays a * whenever a transaction is in process:

psql is an excellent command line tool, but lacks the advanced report formatting facilities of, for example, Oracle's SQL*Plus. However it can be used to output results in several different formats including CSV.

Containing mainly bugfixes, localisation commits and more modifications for Windows32. The changelog from Beta 3 is at ftp://ftp.postgresql.org/pub/source/v8.0.0beta/ChangeLog-Beta3-to-Beta4. This is likely to be the last Beta release before the Release Candidates become available.

• Mirrors: http://www.postgresql.org/mirrors-ftp.html
• Bittorrent: http://bt.postgresql.org
• pginstaller (for Win32): http://pgfoundry.org/projects/pginstaller/

A potential 'data loss' bug and several minor fixes are covered by the latest PostgreSQL "point" releases: 7.2.6, 7.3.8 and 7.4.6 (announcement). Additionally a minor security risk involving the script make_oidjoins_check's use of temporary files has been fixed.

Source files are available from FTP mirrors, see http://www.postgresql.org/mirrors-ftp.html.

UPDATE: apparently two further, slightly more serious but non-specified security fixes are included in these releases.

The next release of PostgreSQL will be 8.0, the first major version number change since 2000. Expected before the end of the year, 8.0 is not a radical makeover, but contains a bundle of new features improving accessibility, functionality and performance for developers, administrators and users alike.