PostgreSQL 7.3 Released

Posted on 2002-11-28

The PostgreSQL Global Development Group proudly announces 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.

Here is what some current PostgreSQL users have gone on record to say about this technology:

"PostgreSQL has scaled perfectly with our rapidly expanding business, and we recommend it over every other DB."

-- TrustCommerce, California

"PostgreSQL provided sales.org with a solution that was $70,000 less expensive to create, and over 70% lower in cost to operate and maintain than any of the commercial DBMS offerings we looked at."

-- sales.org Inc., Toronto

"PostgreSQL handles virtually all the standard SQL constructs. It is easy

(relatively speaking) to administer, it is fast, it is efficient, it has a great API, and it supports ODBC, why would you choose something else?"

-- Mohawk Software, Massachusetts

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, nd other permissions and settings to ncrease the database administrator's ranular 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

  • Supports 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.

Source for this release is available at:

http://advocacy.postgresql.org/download/

More information on PostgreSQL is available in nine languages on the PostgreSQL Advocacy website:

http://advocacy.postgresql.org

A complete list of changes in PostgreSQL version 7.3 can be found in the HISTORY file included with the release, or available on the web at:

http://advocacy.postgresql.org/changes/73/

About PostgreSQL:

With more than 16 years of development by hundreds of the world's most generous and brilliant minds from the open source community, PostgreSQL is the world's most advanced open source database. With its long time support of an enterprise level feature set including transactions, stored procedures, triggers, and subqueries, PostgreSQL is being used by many of today's most demanding businesses.

Corporations such as BASF, Red Hat, Afilias Limited (suporting the technical

backend of the .org and .info domains), Cisco, Chrysler, and 3Com rely on PostgreSQL's rock solid performance record and open development process.

PostgreSQL is available under a BSD License for both commercial and non-commercial use.

To find out more about PostgreSQL or to download it, please visit:

http://advocacy.postgresql.org

This post has been migrated from a previous version of the PostgreSQL website. We apologise for any formatting issues caused by the migration.