PostgreSQL 8.2 Enters Beta [LWN.net]

A beta release of version 8.2 of the PostgreSQL object-relational database management system has been announced:

Feature freeze for version 8.2 took place on August 1st, 2006. Since that time we have gone through the submitted patch queue and applied all outstanding patches that were deemed ready for release. As of this time, we are now releasing beta releases for all to test.

[PostgreSQL] The major changes in version 8.2 include:

The addition of return values to the query language INSERT/UPDATE/DELETE actions.
Support for multi-row VALUES lists.
The ability to use a target table alias with UPDATE and DELETE.
Non-blocking index creation for INSERT/UPDATE/DELETE operations.
Performance optimizations for query, sorting and vacuuming operations.
Locking concurrency improvements.
Improvements to the administration of warm standby servers.
The addition of the FILLFACTOR keyword for tables and indexes.
Improvements to the monitoring and logging systems.
Better control for creating and dropping of objects.
The ability to modify table inheritance relationships for pre-existing tables.
The ability to use COPY TO for processing SELECT statement output.
Support for null values in arrays.
Improvements to aggregate functions.
Other user contributed improvements.

A much more detailed listing of improvements is shown in the version 8.2 release notes.

A new version of the PostgreSQL documentation is also being released with version 8.2.

Testing help has been requested, the code is available for download here.

(Log in to post comments)

No such thing as OR

Posted Nov 2, 2006 11:19 UTC (Thu) by leandro (guest, #1460) [Link]

There is no such thing as Object-Relational. It is not relational, because it is SQL. No matter what market says, relational is a formal concept.