PostgreSQL Release History

Bruce Momjian

Release 1.02

Date: 1996-08-01

• Initial release by PostgreSQL Global Development Team
• Apply all outstanding email patches.

Release 1.09

Date: 1996-11-04

• Fixes for server and command failures.

Release 6.0

Date: 1997-01-29

• Unique indexes
• GIST added
• Improved authentication
• IN/BETWEEN added

Release 6.1

Date: 1997-06-08

• New data types: DATETIME, TIMESPAN, CIRCLE
• GEQO
• Improved optimizer statistics
• Libpq++ overhauled
• Multi-column btree indexes
• new SET/SHOW/RESET commands
• New SEQUENCE feature

Release 6.2

Date: 1997-10-02

• New Java JDBC driver
• Triggers added
• Server Programming Interface (SPI) added
• NOT NULL constraint
• DEFAULT and CONSTRAINT added
• ANSI functions added for DATE/TIME and PRECISION

Release 6.3

Date: 1998-03-01

• Subselcts
• Unix domain socket support for performance
• Improved user password configuration
• Much improved documentation
• Separate permissions for VIEWs
• PRIMARY KEY support
• PL/TCL procedural language added
• UNION added
• Python added
• ECPG added
• New ODBC driver
• Pgaccess added

Release 6.4

Date: 1998-10-30

• Improved RULEs and VIEWs
• PL/PgSQL added
• Multi-byte character support
• Internet address data types
• HAVING added

Release 6.5

Date: 1999-06-09

• MVCC
• Live backups
• NUMERIC data type
• Temporary tables
• CASE
• INTERSECT
• EXCEPT
• LIMIT/OFFSET
• SELECT...FOR UPDATE
• Optimizer overhaul

Release 7.0

Date: 2000-05-08

• Foreign keys
• More optimizer improvements
• ANSI JOIN syntax
• PL/Perl
• Oracle compatibility functions

Release 7.1

Date: 2001-04-13

• Write-ahead Log (WAL)
• TOAST
• Outer Joins
• Overhauled function manager