PostgreSQL 6.4

• Release notes
• Released: 1998-10-30 (announcement)
• Final minor version: 6.4.2
• EOL: 1998-12
• Documentation: PostgreSQL 6.4

Major features

• VIEWs (read-only)
• RULEs
• PL/pgSQL
• Frontend/Backend Protocol version 2 introduced

SQL changes

Added:

• CREATE SEQUENCE (commit 9729f6ca)
• DROP SEQUENCE (commit 9729f6ca)
• UNLISTEN (commit f62d1253)

Modified:

• DROP RULE
  • made functional (initial commit 15cb32d9)
• SET
  • SET NAMES syntax added (commit bf00bbb0)

Data type changes

Added:

• cidr (commit 858a3b57)
• inet (initial commit 2d69fd90)
• serial pseudo-type (initial commit 12cf9f80)

System catalogue changes

Tables

Modified:

• pg_database
  • column encoding added (commit bf00bbb0)

Views

Added:

• pg_rules (commit 15cb32d9)
• pg_views (commit 15cb32d9)
• pg_indexes (commit f93b6974)
• pg_tables (commit f93b6974)

System functions

Added:

• octet_length() (commit f554af0a)
• pg_get_indexdef() (commit f93b6974)
• pg_get_ruledef() (commit 15cb32d9)
• pg_get_userbyid() (commit f93b6974)
• pg_get_viewdef() (commit 15cb32d9)
• version() (commit 51a1741c)

Core utilities

Modified:

• pg_dump
  • support for dumping views added (commit b7ed6f85)
  • -n option added (commit 96019647)
  • -N option added (commit 89072303)

Procedural languages

• PL/pgSQL added (initial commit 863a6206)

Contrib modules

Added:

• earthdistance (commit 5815523b)
• isbn_issn (commit 3fa676a7)
• lo (commit 7784312f).