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 (initial commit ed5003c5)
- SQL syntax updated to allow more complex queries
- Grand Unified Configuration (initial commit 6a68f426)
SQL changes
Added:
CHECKPOINT
(commit f0e37a85)
Modified:
ALTER USER
COPY
- new file format for binary copy mode (commit 676cf18c)
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
System catalogue changes
Tables
Added:
pg_largeobject
(commit cf5a950c)
Removed:
System function changes
Added:
abbrev()
(commit 61784c54)chr()
(commit ebdfac3b)format_type()
(commit de85dd1d)quote_ident()
(commit daf1e3a7)quote_literal()
(commit daf1e3a7)to_ascii()
(commit 75b61043)
Removed:
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_query
(commit 6a68f426)debug_print_rewritten
(commit 6a68f426)debug_pretty_print
(commit 6a68f426)geqo
(commit 6a68f426)geqo_random_seed
(commit 6a68f426)geqo_threshold
(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)port
(commit 6a68f426)silent_mode
(commit 2af8b963)shared_buffers
(commit 6a68f426)sql_inheritance
(commit c4465095)ssl
(commit ffd9aaa0)tcpip_socket
(initial commit 6a68f426)trace_spinlocks
(commit 6a68f426)unix_socket_directory
(initial commit 2150c2ed)unix_socket_group
(commit d1bfa6c7)unix_socket_permissions
(commit d1bfa6c7)virtual_host
(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:
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
andCREATE GROUP
rather than copies ofpg_shadow
andpg_group
(commit 51afb930)
- use
Contrib modules
Added: