PostgreSQL 7.3

• Release notes
• Released: 2002-11-27 (announcement)
• Final minor version: 7.3.21
• EOL: 2007-11
• Documentation: PostgreSQL 7.3

Major features

• schema (namespace) support added (initial commit 95ef6a34)
• table functions
• domains
• prepared queries
• pg_resetxlog introduced (commit 33e3c9b0)

SQL changes

Added:

• ALTER DATABASE (commit 1aac2c85)
• ALTER TRIGGER (commit 3a96b6cd)
• CREATE CAST (commit 97377048)
• CREATE CONVERSION (initial commit fcc96256)
• CREATE DOMAIN (commit 01c76f74)
• CREATE OPERATOR CLASS (initial commit ea4686e3)
• CREATE SCHEMA (initial commit 95ef6a34)
• DEALLOCATE (commit 28e82066)
• DROP CAST (commit 97377048)
• DROP CONVERSION (initial commit fcc96256)
• DROP DOMAIN (commit 01c76f74)
• DROP OPERATOR CLASS (initial commit ea4686e3)
• DROP SCHEMA (initial commit 11333426)
• EXECUTE (commit 28e82066)
• PREPARE (commit 28e82066)
• RESET SESSION AUTHORIZATION (commit 28227889)
• START TRANSACTION (commit 19e0e35b)

Modified:

• ALTER TABLE
  • ALTER TABLE ... SET STORAGE ... syntax added (commit 03194432)
• ALTER USER
  • ALTER USER ... [ SET ... | RESET ... ] syntax added (commit 1aac2c85)
• COMMENT ON
  • COMMENT ON CONSTRAINT added (commit 7c6df91d)
  • COMMENT ON DOMAIN added (commit d3788c33)
  • COMMENT ON RULE ... ON TABLE ... syntax added (commit b3120804)
  • COMMENT ON SCHEMA added (commit f69bc37b)
• COPY
  • option handling standardized via WITH clause (commit c2c2fd57)
  • individual table columns can be specified for input and output operations (commit a90db34b)
  • an error will be raised if no table columns are specified for input operations and the source data does not contain all table colums (commit 874148fe)
  • COPY TO outputs embedded carriage returns and newlines as \r and \n (commit 9832a235)
  • DELIMITER string can be an 8-bit character (commit 21f9a654)
• CREATE DATABASE
  • OWNER option added (commit a833c441)
• CREATE FUNCTION
  • syntax revised to match SQL99 standard (commit 94bdc485)
• CREATE LANGUAGE
  • VALIDATOR option added (commit d60f10b0)
  • PROCEDURAL keyword now optional (commit 4b71943b)
• CREATE RULE
  • CREATE [ OR REPLACE ] RULE syntax added (commit 248c67d7)
• CREATE TYPE
  • CREATE TYPE ... AS ( column_name data_type [, ... ] ) syntax added (commit b1a5f872) 
  • options EXTERNALLENGTH, VARIABLE, SEND and RECEIVE removed (commit 739adf32)
• CREATE VIEW
  • CREATE [ OR REPLACE ] VIEW syntax added (commit 248c67d7)
• DROP AGGREGATE
  • CASCADE and RESTRICT clauses added (commit 7c6df91d)
• DROP FUNCTION
  • CASCADE and RESTRICT clauses added (commit 7c6df91d)
• DROP INDEX
  • CASCADE and RESTRICT clauses added (commit 7c6df91d)
• DROP LANGUAGE
  • CASCADE and RESTRICT clauses added (commit 7c6df91d)
• DROP OPERATOR
  • CASCADE and RESTRICT clauses added (commit 7c6df91d)
• DROP RULE
  • CASCADE and RESTRICT clauses added (commit 7c6df91d)
  • DROP RULE ... ON TABLE ... syntax added (commit b3120804)
• DROP SEQUENCE
  • CASCADE and RESTRICT clauses added (commit 7c6df91d)
• DROP TABLE
  • CASCADE and RESTRICT clauses added (commit 131f801d)
• DROP TRIGGER
  • CASCADE and RESTRICT clauses added (commit 131f801d)
• DROP TYPE
  • CASCADE and RESTRICT clauses added (commit 7c6df91d)
• DROP VIEW
  • CASCADE and RESTRICT clauses added (commit 131f801d)
• GRANT
  • GRANT ... ON DATABASE syntax added (initial commit b0bcf8aa)
  • GRANT ... ON SCHEMA syntax added (initial commit b0bcf8aa)
  • GRANT ... ON [ TABLE ] syntax extended with TO { username | GROUP groupname | PUBLIC } (initial commit b0bcf8aa)
• INSERT
  • support for DEFAULT keyword added (commit 97b4e5ad)
• SET
  • SET [ SESSION | LOCAL ] syntax added (commit f0811a74)
• SET SESSION AUTHORIZATION
  • SET SESSION AUTHORIZATION DEFAULT syntax added (commit 28227889)
  • SET [ SESSION | LOCAL ] SESSION AUTHORIZATION syntax added (commit f0811a74)
• SET TRANSACTION
  • READ ONLY and READ WRITE syntax added (commit 90edb265)

Backend changes

• NAMEDATALEN changed from 32 bytes to 64 bytes (commit 46bb23ac)
• support for version 0 of the Frontend/Backend_Protocol removed (commit 5241a625))

Data type changes

Added:

• regclass (commit 52200bef)
• regoper (commit 52200bef)
• regoperator (commit 52200bef)
• regproc (commit 52200bef)
• regprocedure (commit 52200bef)
• regtype (commit 52200bef)

System catalog changes

Tables

Added:

• pg_cast (commit 97377048)
• pg_constraint (commit 7c6df91d)
• pg_conversion (commit fcc96256)
• pg_depend (commit 7c6df91d)
• pg_namespace (commit a25b94c0)

Modified:

• pg_attribute
  • column attislocal added (commit c328b6dd)
  • column attinhcount added (commit c328b6dd)
• pg_class
  • column relnamespace added (commit 1dbf8aa7)
• pg_database
  • column datconfig added (commit 1aac2c85)
  • column datacl added (commit b0bcf8aa)
• pg_language
  • column lancompiler removed (commit 739adf32)
  • column lanvalidator added (commit d60f10b0)
  • column lanacl added (commit 8adf56f7)
• pg_proc - following columns removed (commit 739adf32):
  • proimplicit
  • probyte_pct
  • properbyte_cpu
  • propercall_cpu
  • prooutin_ratio
• pg_operator - following columns removed (commit 739adf32):
  • oprprec
  • oprisleft
• pg_shadow
  • column usetrace removed (commit 739adf32)
• pg_type - following columns removed (commit 739adf32):
  • typprtlen
  • typreceive
  • typsend

Removed:

• pg_relcheck - replaced by pg_constraint and pg_depend (commit 7c6df91d)

Views

Added:

• pg_locks (commit 82119a69)
• pg_settings (commit 45e25445)
• pg_stats (commit 16ea152b)

Modifed:

• pg_indexes
  • column schemaname added (commit 3b78826b)
• pg_rules
  • column schemaname added (commit 3b78826b)
• pg_tables
  • column schemaname added (commit 3b78826b)
• pg_user
  • column useconfig added (commit 1aac2c85)
  • column usetrace removed (commit 739adf32)
• pg_views
  • column schemaname added (commit 3b78826b)

System functions

Added:

• current_database() (commit de9801fc)
• current_schema() (commit a309032d)
• current_schemas() (commit a309032d)
• current_setting() (commit 7ef56347)
• has_database_privilege() (commit 4ab8e690)
• has_function_privilege() (commit 4ab8e690)
• has_language_privilege() (commit 4ab8e690)
• has_schema_privilege() (commit 4ab8e690)
• localtime (commit 133df7ce)
• localtimestamp (commit 133df7ce)
• overlay() (commit 090dd22d)
• pg_backend_pid() (initial commit f67cb719)
• pg_function_is_visible() (commit 4ab8e690)
• pg_get_constraintdef() (commit a208ea72)
• pg_opclass_is_visible() (commit 4ab8e690)
• pg_operator_is_visible() (commit 4ab8e690)
• pg_stat_reset() (commit 5243f9a9)
• pg_table_is_visible() (commit 4ab8e690)
• pg_type_is_visible() (commit 4ab8e690)
• replace() (commit 89260124)
• set_config() (commit 7ef56347)
• split_part() (initial commit 89260124)
• to_hex() (commit 89260124)
• treat() (commit 68d9fbeb)

Modified:

• substring()
  • SUBSTRING(string FROM pattern [ FOR escape ]) variant added (commit 090dd22d)

Configuration changes

Added:

• autocommit (commit 26993b29)
• client_min_messages (commit a033daf5)
• db_user_namespace (commit 2c6b34d9)
• default_statistics_target (commit ce7565ab)
• explain_pretty_print (commit 10d39950)
• fsync (commit 6a68f426)
• lc_messages (commit 867901db)
• lc_monetary (commit 867901db)
• lc_numeric (commit 867901db)
• lc_time (commit 867901db)
• log_min_error_statement (commit 9fd842c4)
• log_statement (commit 548d646e)
• DateStyle (commit f0811a74
• search_path (commit 838fe25a)
• server_min_messages (commit a033daf5)
• statement_timeout (commit 4db8718e)
• superuser_reserved_connections (commit 626eca69)
• TimeZone (commit f0811a74)

Removed:

• debug_level (commit a033daf5)
• debug_print_query (commit 548d646e)

Authentication changes

pg_hba.conf

• column USER added (commit 43a3543a)

Core utilities

Added:

• pg_controldata (converted from contrib module, commit 6945ea34)

Modified:

• clusterdb
  • added (commit c0ad5953)
• createdb
  • support for identifiers containing spaces added (commit 5804a7ce)
• createlang
  • support for identifiers containing spaces added (commit 5804a7ce)
• createuser
  • support for identifiers containing spaces added (commit 5804a7ce)
• dropdb
  • support for identifiers containing spaces added (commit 5804a7ce)
• droplang
  • support for identifiers containing spaces added (commit 5804a7ce)
• dropuser
  • support for identifiers containing spaces added (commit 5804a7ce)
• pg_dump
  • primary keys will be retrospectively added to tables with ALTER TABLE ... ADD PRIMARY KEY to avoid index creation penalty during a later restore (commit 5b5cef9a)
  • various output portability improvements (commit c828ec88)
  • support for objects larger than 2GB (commit 38e444aa)
• pg_restore
  • option --disable-triggers added (commit 9f0ae0c8)
• vacuumdb
  • support for identifiers containing spaces added (commit 5804a7ce)

psql

• \dD command to list available domains added (commit a7ade2bb)
• rules on views now displayed (commit aab0b8f5)

Contrib modules

Added:

• dbsize (commit ad0787b2)
• intagg (commit 2146d8c6)
• ltree (commit 1dedbf2d)
• reindexdb (commit 485fc354)
• tablefunc (commit 41f862ba)

Removed:

• pg_controldata became part of the core PostgreSQL distribution (commit 6945ea34)