PostgreSQL 7.1

• Release notes
• Released: 2001-04-13 (announcement)
• Final minor version: 7.1.3
• EOL: 2001-08
• Documentation: PostgreSQL 7.1

Major features

• WAL
• TOAST tables
• outer join syntax
• SQL syntax updated to allow more complex queries

SQL changes

Added:

• CHECKPOINT (commit f0e37a85)

Modified:

• ALTER USER
  • IN GROUP option (which was previously parsed but had no effect) removed (commit 4ceb2d0c)
  • SYSID option removed (commit 4ceb2d0c)
• CREATE DATABASE
  • WITH TEMPLATE clause added to enable selection of a template database as an alternative to the default "template0" (commit 2cf48ca0)

Backend changes

• pg_control added (commit 4d14fe00)
• GUC configuration system added (commit 6a68f426)
• revised function mananger (fmgr) interface (commit 0a7fb4e9)
• template0 database added (commit 2cf48ca0)
• automatic checkpointing added (commit b0299c5d)

Process management

• postmaster.pid
  • line with shared memory key added (commit 4d14fe00)
  • line with data directory added (commit 792b0f46)

System catalogue changes

Tables

Added:

• pg_largeobject (commit cf5a950c)

Removed:

• pg_log (commit 2589735d)

System function changes

Added:

• chr() (commit ebdfac3b)
• format_type() (commit de85dd1d)
• quote_ident() (commit daf1e3a7)
• quote_literal() (commit daf1e3a7)
• to_ascii() (commit 75b61043)

Removed:

• ichar() (renamed to chr(); commit ebdfac3b)

Configuration changes

General:

• Sample postgresql.conf file added (initial commit 209aa77d)

Added:

• checkpoint_segments (commit 4d14fe00)
• checkpoint_timeout (commit b0299c5d)
• commit_delay (commit 74151052)
• commit_siblings (commit 9c993658)
• debug_assertions (commit 648677c3)
• debug_print_parse (commit 6a68f426)
• debug_print_plan (commit 6a68f426)
• debug_print_rewritten (commit 6a68f426)
• debug_pretty_print (commit 6a68f426)
• krb_server_keyfile (commit 996832ca)
• log_connections (commit 6a68f426)
• max_connections (commit 6a68f426)
• show_executor_stats (commit 6a68f426)
• show_parser_stats (commit 6a68f426)
• show_planner_stats (commit 6a68f426)
• show_statement_stats (commit 6a68f426)
• silent_mode (commit 2af8b963)
• trace_spinlocks (commit 6a68f426)
• unix_socket_directory (initial commit 2150c2ed)
• wal_buffers (commit b0299c5d)
• wal_debug (commit b0299c5d)
• wal_sync_method (commit 9d645fd8)

libpq changes

• connection service file (pg_service.conf) support added (initial commit f2ef4df4)

Server utilities

Added:

• pg_config (commit 93141411)

Core utilities

Added:

• pg_restore (commit 500b62b0)

Modified:

• createdb
  • --template option added (commit c3b00e7e)
• pg_dump
  • support for TAR output (commit c3e18804)
  • support for dumping large objects (commit e8f69be0)
• pg_dumpall
  • use CREATE USER and CREATE GROUP rather than copies of pg_shadow and pg_group (commit 51afb930)

Contrib modules

Added:

• cube (commit 9892ddf5)
• intarray (commit 1db943b3)
• oid2name (commit 2c591cb8
• pgcrypto (commit 0c0dde61)
• seg (commit a3694b42)
• start-scripts (commit bbac19a9)