Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Tips Database Forum

» Database Journal Home
» Database Articles
» Database Tutorials
MS Access
SQL Scripts & Samples
» Database Forum
» Slideshows
Free Newsletters:

News Via RSS Feed

Database Journal |DBA Support |SQLCourse |SQLCourse2

Featured Database Articles

Database News

Posted Dec 3, 2002

PostgreSQL Version 7.3 Released

By DatabaseJournal.com Staff

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
  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:

Back to Database Journal Home

Database News Archives

Latest Forum Threads
Database News Forum
Topic By Replies Updated
Efficient SQL Server Indexing by Design lcole 0 April 30th, 12:38 PM
Mine Oracle Database, SQL Server and Other Databases with Monarch Data Pump Pro V10.5 lcole 0 April 30th, 12:37 PM
Oracle Database and Oracle Fusion Middleware for Private Social Network Application lcole 0 April 30th, 12:31 PM
Oracle Database Maintains a Stronghold in the DBMS Market lcole 0 April 30th, 12:30 PM