Postgres95

Postgres95 was the first open-source, SQL-based version of the POSTGRES codebase; as the name implies, it was released in 1995; the code was used to form the base of the open source PostgreSQL project's repository in July 1996.

Change history

This list contains references to significant commits which occurred following the establishment of the PostgreSQL project CVS repository and before the PostgreSQL 6.0 release.

Note that there is no longer any release information (commit tags or release notes) for releases 1.03 to 1.07, and the 1.09 release notes state "Sorry, we stopped keeping track of changes from 1.02 to 1.09.".

All commit references are to the current GIT repository.

• 1997-01-29
  • commit 2ffba0d4 appears to mark the release of PostgreSQL 6.0 (though there is no tag for this release)
• 1997-01-23
  • initial autoconf support (commit 2732075b)
• 1997-01-16
  • pg_dumpall added (commit 3d97a61a)
• 1997-01-15
  • user manual added as HTML (commit 59bb41a2)
• 1997-01-07
  • pg_dump can dump views (commit 73b6ffbf)
• 1996-12-17
  • GROUP BY works with aliases; ORDER BY works with numeric column references (commit db7a90f1)
• 1996-12-11
  • Postgres95 renamed to PostgreSQL (initial commit 9b41da6c)
• 1996-11-30
  • some aggregate function support (commit f0a9e64a)
  • BETWEEN and IN support added (commit 2d7aacb0)
• 1996-11-14
  • PGDATA no longer has a compiled-in default (commit f64b8403)
• 1996-11-13
  • CREATE UNIQUE INDEX added (commit 07a65b22)
• 1996-10-31
  • version 1.09 release (tag PG95-1_09; associated commit 1b5e30e6)
• 1996-10-30
  • parser overhaul (commit f59a46a8)
• 1996-10-12
  • pg_hba.conf authentication added (initial commit 57026d60)
• 1996-10-04
  • version 1.08 release (tag PG95-1_08, associated commit bf3473c4)
• 1996-10-03
  • VACUUM tablename added (commit 267ef0a6)
• 1996-09-16
  • first mention of a 2.0 release (commit 40aade2c)
• 1996-08-26
  • include files centralized into src/include/ (initial commit 51b3f2d3)
• 1996-08-26
  • GiST support added (initial commit a2740a45)
• 1996-08-24
  • WITH OIDS option added to COPY (commit 208a30f2)
• 1996-08-15
  • CREATE INDEX defaults to btree access method (commit a4402ecc)
• 1996-08-13
  • libpq function PQgetisnull() added (commit 9305fc74)
• 1996-08-06
  • support for IS NULL and IS NOT NULL expressions added (commit bb0bdfd1)
  • support for ORDER BY table_name.column_name syntax added (commit 6c684b18)
• 1996-08-01
  • Release 1.02 (no commit tag for this release)
• 1996-07-25
  • monitor client replaced by psql (initial commit 69ee15d6)
• 1996-07-19
  • support for NULL values added (commit 20288400)
• 1996-07-09
  • initial repository import (commit d31084e9)

Historical release notes

The PostgreSQL documentation contains release notes for the following Postgres95 versions, which were released before the initial repository import:

• 1996-02-03
  • Release 1.01
• 1995-09-05
  • Release 1.0
• 1995-07-21
  • Postgres95 Release 0.03
• 1995-03-25
  • Postgres95 Release 0.02
• 1995-05-01
  • Postgres95 Release 0.01

Historical source code

A collection of pre-PostgreSQL source code is available here: https://dsf.berkeley.edu/oldpost/