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)

Backend changes

• NAMEDATALEN changed from 16 to 32 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)

psql

• \ds slash command to list available sequences added (commit 735bf0b7)
• \dt and \di slash commands to list available tables and indexs added (commit ff038a5b)
• \z slash command added (commit f986173e)