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:
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
Contrib modules
Added: