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:

• pg_ctl (commit 5b912b08)

Modified:

• initdb
  • interactive password prompts added (commit 2a1bfbce)

Core utilities

Added:

• createdb (commit 240e4c98)
• createuser (commit 240e4c98)
• dropdb (commit 240e4c98)
• dropuser (commit 240e4c98)
• vacuumdb (commit 240e4c98)

Modified:

• pg_dump
  • support for emitting COMMENT statements (commit 2eebcdde)
  • support for emitting PRIMARY KEY definitions (commit e639a1a6)
  • support for long command line options added (commit 5ca971a1)
• psql
  • tab completion support added (commit 78bc83fe)

Contrib modules

Added:

• pgbench (commit a765db40)