12.02.02. The PostgreSQL Global Development Group yesterday announced the release of version 7.3 of the PostgreSQL object-relational database management system (ORDBMS). PostgreSQL, the world’s most advanced open source database, provides solutions for many of the most demanding
applications in use today, saving businesses and governments millions of dollars each year.
The worldwide PostgreSQL community is very excited about this
release, which includes numerous modifications and enhancements thanks
to the contributions of over 500 developers and thousands of volunteer
testers from more than 50 countries.
“PostgreSQL 7.3 is full of new, oft requested features such as SQL ’92 schemas, prepared statements, and stored procedures that can
return record sets. And under the hood there is a new dependency tracking system that allows PostgreSQL to safely support many more subtle
enhancements like the ability to drop columns,” said Neil Conway, a member of the PostgreSQL Global Development Team.
Among the advances in PostgreSQL version 7.3 are:
- Schemas
PostgreSQL now joins the handful of ORDBMS’s to support
the SQL 92 Schema specification, improving both enterprise
database management and security through the use of namespaces. - Table Functions
PostgreSQL version 7.3 has greatly simplified returning result sets
of rows and columns in database functions. This significantly
enhances the useability of stored procedures in PostgreSQL, and will
make it even easier to port Oracle applications to PostgreSQL. - Security Advances
In response to community demands, PostgreSQL has added schema,
function, and other permissions and settings to increase the database
administrator’s granular control over security.
Other Enhancements to PostgreSQL Version 7.3 include:
– Enhanced dependency tracking for complex databases.
– Prepared queries for maximized performance on common requests.
– Expanded logging options
– Support for data in many international characters sets(UNICODE, EUC_JP, EUC_CN, EUC_KR, JOHAB, EUC_TW,
ISO 8859-1 ECMA-94, KOI8, WIN1256, etc…)
– Dozens of performance enhancements to maintain PostgreSQL’s leading
position in ORDMBSs.
A complete list of changes in PostgreSQL version 7.3 can be found in the history
file included with the release. The list is also available on the web at http://advocacy.postgresql.org/changes/73/. The Source for this release is available at:
http://advocacy.postgresql.org/download/.
Additional information on PostgreSQL is available in nine languages on the PostgreSQL
Advocacy website http://advocacy.postgresql.org.
The complete press release can be found at:
http://techdocs.postgresql.org/guides/Pressrelease73
Back to Database Journal Home