PostgreSQL 6.1
- Release notes
- Released: 1997-06-08
- Final minor version: 6.1.1
- EOL: 1997-07
- Documentation: not available
Major features
- Multicolumn indexes
- sequences (initial commit 4d8e8415)
- money data type (initial commit 4999f002)
- GEQO / GEnetic Query Optimizer (initial commit 29138eeb)
- locale support (initial commit 5b1311ac)
- sequences (initial commit 4d8e8415)
SQL changes
General:
GROUP BY
using function results supported (commit cc11cfdd)
Added:
CREATE SEQUENCE
(commit 9729f6ca)DROP SEQUENCE
(commit 9729f6ca)SET
(initial commit a51df14a)SHOW
(initial commit 4b531912)RESET
(initial commit 4b531912)
Modified:
CREATE INDEX
- proper multicolumn index creation (commit 65019fcf)
VACUUM
- option
ANALYZE
added (commit 24d48db3)
- option
Backend changes
NAMEDATALEN
changed from16
to32
bytes (commit 7492fb16)
System function changes
Added:
currval()
(commit e8647c45)date_part()
(commit 2ab34dfe)initcap()
(commit 83978e1e)lower()
(commit 83978e1e)lpad()
(commit 83978e1e)ltrim()
(commit 83978e1e)nextval()
(commit e8647c45)rpad()
(commit 83978e1e)rtrim()
(commit 83978e1e)substr()
(commit 83978e1e)translate()
(commit 83978e1e)upper()
(commit 83978e1e)
Data type changes
- circle type added and other geometric data types improved (commit 9e2a87b6)
- datetime and timespan data types added (commit dfe04753)
Core utilities
Modified:
pg_dumpall
- enable preservation of database ownership (commit 2fc04874)