PostgreSQL 6.3

• Release notes
• Released: 1998-03-01
• Final minor version: 6.3.2
• EOL: 2003-04
• Documentation: PostgreSQL 6.3

Major features

• SQL-92 subselect ability (commit e51c674c)
• PL/pgTCL
• ECPG added (initial commit 82034103)
• SGML-based documentation (commit c8cfb0ce)

SQL changes

Added:

• ALTER USER (commit 4c04f772)
• CREATE PROCEDURAL LANGUAGE (commit 7bff4c50)
• CREATE TABLE AS (commit 2c833a72)
• CREATE USER (commit 4c04f772)
• DROP LANGUAGE (commit 7bff4c50)
• DROP USER (commit 4c04f772)
• LOCK (commit 7015dfef)

Modified:

• COPY
  • line number reported on failure (commit deea69b9)
• SELECT
  • SQL-92 subselect support added (commit e51c674c)

Backend changes

• Frontend/Backend Protocol - version numbers introduced (commit d5bbe2ac)

System catalogue changes

Tables

Added:

• pg_description (commit 5071ae29)
• pg_shadow (commit 780068f8)

Removed:

• pg_defaults (commit 1c32d285)
• pg_demon (commit 1c32d285)
• pg_hosts (commit 1c32d285)
• pg_magic (commit 1c32d285)
• pg_server (commit 1c32d285)
• pg_time (commit 32cd09ac)
• pg_user replaced by pg_shadow (commit b5b3735f)

Note: tables removed in commit 1c32d285 were apparently unused.

Views

Added:

• pg_user (commit 780068f8)

System function changes

Added:

• current_date (commit f10b6392)
• current_time (commit f10b6392)
• current_timestamp (commit f10b6392)
• current_user (commit f10b6392)
• length() (commit 3551ee09)
• obj_description() (commit 4cbc06cf)

libpq changes

• authtype option deprecated (commit d5bbe2ac)

psql changes

• \da command to list available aggregates added (commit 4cbc06cf)
• \do command to list available operators added (commit 4cbc06cf)
• \dT command to list available data types added (commit 4cbc06cf)

Core utilities

• pg_dump
  • -H option renamed to -h (commit c35d7fb8)

Contrib modules

Added:

• userlock (commit 951986c5)