Distribute prebuilt documentation in a subdirectory tree, rather than as tar archive files inside the distribution tarball (Peter Eisentraut) For example, the prebuilt HTML documentation is now in doc/src/sgml/html/ ; the manual pages are packaged similarly.

Make the server's lexer reentrant (Tom Lane) This was needed for use of the lexer by PL/pgSQL.

Improve speed of memory allocation (Tom Lane, Greg Stark)

User-defined constraint triggers now have entries in pg_constraint as well as pg_trigger (Tom Lane) Because of this change, pg_constraint . pgconstrname is now redundant and has been removed.

Add system catalog columns pg_constraint . conindid and pg_trigger . tgconstrindid to better document the use of indexes for constraint enforcement (Tom Lane)

Allow multiple conditions to be communicated to backends using a single operating system signal (Fujii Masao) This allows new features to be added without a platform-specific constraint on the number of signal conditions.

Improve source code test coverage, including contrib , PL/Python, and PL/Perl (Peter Eisentraut, Andrew Dunstan)

Remove the use of flat files for system table bootstrapping (Tom Lane, Alvaro Herrera) This improves performance when using many roles or databases, and eliminates some possible failure conditions.

Automatically generate the initial contents of pg_attribute for "bootstrapped" catalogs (John Naylor) This greatly simplifies changes to these catalogs.

Split the processing of INSERT / UPDATE / DELETE operations out of execMain.c (Marko Tiikkaja) Updates are now executed in a separate ModifyTable node. This change is necessary infrastructure for future improvements.

Simplify translation of psql's SQL help text (Peter Eisentraut)

Reduce the lengths of some file names so that all file paths in the distribution tarball are less than 100 characters (Tom Lane) Some decompression programs have problems with longer file paths.

Add a new ERRCODE_INVALID_PASSWORD SQLSTATE error code (Bruce Momjian)

With authors' permissions, remove the few remaining personal source code copyright notices (Bruce Momjian) The personal copyright notices were insignificant but the community occasionally had to answer questions about them.

Add new documentation section about running PostgreSQL in non-durable mode to improve performance (Bruce Momjian)

Restructure the HTML documentation Makefile rules to make their dependency checks work correctly, avoiding unnecessary rebuilds (Peter Eisentraut)

Use DocBook XSL stylesheets for man page building, rather than Docbook2X (Peter Eisentraut) This changes the set of tools needed to build the man pages.

Improve PL/Perl code structure (Tim Bunce)