PostgreSQL 7.0
- Release notes
- Released: 2000-05-08
- Final minor version: 7.0.3
- EOL: 2000-11
- Documentation: PostgreSQL 7.0
Major features
- foreign keys
- SQL-92 join syntax
SQL changes
Added:
ALTER GROUP
(commit 99b8f845)COMMENT ON
(commit 7acc2377)CREATE GROUP
(commit 99b8f845)DROP GROUP
(commit 99b8f845)REINDEX
(commit e3a97b37)TRUNCATE
(commit e7cad7b0)
Modified:
ALTER TABLE
ALTER TABLE ... DROP COLUMN ...
added (initial commit fa5400c0)
ALTER USER
SYSID
option added (commit eebfb9ba)
Backend changes
Process management
postmaster.opts
added (commit dde36bfb)postmaster.pid
added (commit dde36bfb)
System function changes
Added:
ascii()
(commit a349733b)date_trunc()
(commit 64568100)factorial()
(commit 64568100)ichar()
(commit a349733b)pg_char_to_encoding()
(commit 5eb1d0de)pg_encoding_to_char()
(commit 5eb1d0de)repeat()
(commit a349733b)setseed()
(commit a349733b)to_char()
(initial commit b866d2e2)to_date()
(initial commit b866d2e2)to_number()
(initial commit b866d2e2)to_timestamp()
(initial commit b866d2e2)
Configuration changes
Added:
cpu_tuple_cost
(commit b1577a7c)cpu_index_tuple_cost
(commit b1577a7c)cpu_operator_cost
(commit b1577a7c)effective_cache_size
(commit b1577a7c)enable_seqscan
(commit b1577a7c)enable_indexscan
(commit b1577a7c)enable_tidscan
(commit b1577a7c)enable_sort
(commit b1577a7c)enable_nestloop
(commit b1577a7c)enable_mergejoin
(commit b1577a7c)enable_hashjoin
(commit b1577a7c)random_page_cost
(commit b1577a7c)
Server utilities
Added:
Modified:
Core utilities
Added:
createdb
(commit 240e4c98)createuser
(commit 240e4c98)dropdb
(commit 240e4c98)dropuser
(commit 240e4c98)vacuumdb
(commit 240e4c98)
Modified:
Contrib modules
Added: