From 349d529abf6ccd0caa8bf7d3fb4cfe959c4f47a3 Mon Sep 17 00:00:00 2001 From: Tom Lane Date: Sat, 23 Nov 2002 02:41:03 +0000 Subject: [PATCH] Release note improvements (Neil, Tom) --- doc/src/sgml/release.sgml | 51 ++++++++++++++++++++++++++------------- 1 file changed, 34 insertions(+), 17 deletions(-) diff --git a/doc/src/sgml/release.sgml b/doc/src/sgml/release.sgml index bf8988e0c33..de439f3713d 100644 --- a/doc/src/sgml/release.sgml +++ b/doc/src/sgml/release.sgml @@ -1,5 +1,5 @@ @@ -47,7 +47,7 @@ worries about funny characters. Schemas - Schemas allow users to create objects in their own namespace + Schemas allow users to create objects in separate namespaces, so two people or applications can have tables with the same name. There is also a public schema for shared tables. Table/index creation can be restricted by removing permissions @@ -148,7 +148,10 @@ worries about funny characters. By default, functions can now take up to 32 parameters, and - identifiers can be up to 63 bytes long. + identifiers can be up to 63 bytes long. Also, OPAQUE + is now deprecated: there are specific pseudo-datatypes + to represent each of the former meanings of OPAQUE + in function argument and result types. @@ -191,7 +194,7 @@ worries about funny characters. Several postgresql.conf logging parameters - have been renamed and improved. + have been renamed. @@ -205,14 +208,18 @@ worries about funny characters. INSERT statements with column lists must - specify all values; e.g., INSERT INTO tab (col1, col2) - VALUES ('val1') is now invalid. + specify a value for each specified column. For example, + INSERT INTO tab (col1, col2) VALUES ('val1') + is now invalid. It's still allowed to supply fewer columns than + expected if the INSERT does not have a column list. - An index is now not automatically created for serial columns. + serial columns are no longer automatically + UNIQUE; thus, an index will not automatically be + created. @@ -227,14 +234,16 @@ worries about funny characters. COPY no longer considers missing trailing columns to be null. All columns need to be specified. + (However, one may achieve a similar effect by specifying a + column list in the COPY command.) The data type timestamp is now equivalent to - timestamp without timezone, instead of - timestamp with timezone. + timestamp without time zone, instead of + timestamp with time zone. @@ -244,7 +253,15 @@ worries about funny characters. dependencies for serial columns, unique constraints, and foreign keys. See the directory contrib/adddepend/ for a detailed - description and a script that will add the such dependencies. + description and a script that will add such dependencies. + + + + + + An empty string ('') is no longer allowed as + the input into an integer field. Formerly, it was silently + interpreted as 0. @@ -282,7 +299,7 @@ Improve performance of query tokenization and network handling (Peter) Speed improvement for large object restore (Mario Weilguni) Mark expired index entries on first lookup, saving later heap fetches (Tom) -Eliminate NULL bitmap padding when not required (Manfred) +Avoid excessive NULL bitmap padding (Manfred Koizar) Add BSD-licensed qsort() for Solaris, for performance (Bruce) Reduce per-row overhead by four bytes (Manfred Koizar) Fix GEQO optimizer bug (Neil Conway) @@ -348,7 +365,7 @@ Make cursors insensitive, meaning their contents do not change (Tom) Disable LIMIT #,# syntax; now only LIMIT # OFFSET # supported (Bruce) Increase identifier length to 63 (Neil, Bruce) UNION fixes for merging >= 3 columns of different lengths (Tom) -Add DEFAULT keyword to INSERT, e.g., INSERT ... (..., DEFAULT, ) +Add DEFAULT keyword to INSERT, e.g., INSERT ... (..., DEFAULT, ...) (Rod) Allow views to have default values using ALTER COLUMN ... SET DEFAULT (Neil) @@ -372,7 +389,7 @@ Add variable autocommit (Tom, David Van Wie) Object Manipulation Make equals signs optional in CREATE DATABASE (Gavin Sherry) -Make ALTER TABLE OWNER to change index ownership (Neil) +Make ALTER TABLE OWNER change index ownership too (Neil) New ALTER TABLE tabname ALTER COLUMN colname SET STORAGE controls TOAST storage, compression (John Gray) Add schema support, CREATE/DROP SCHEMA (Tom) @@ -424,7 +441,7 @@ Allow comments on operators, independent of the underlying function (Rod) Rollback SET commands in aborted transactions (Tom) EXPLAIN now outputs as a query (Tom) -Display sort keys in EXPLAIN (Tom) +Display condition expressions and sort keys in EXPLAIN (Tom) Add 'SET LOCAL var = value' to set configuration variables for a single transaction (Tom) Allow ANALYZE to run in a transaction (Bruce) @@ -518,7 +535,7 @@ Fix trigger/type/language functions returning OPAQUE to return Internationalization -Add additional encodings (Korean (JOHAB), Thai (WIN874), Vietnamese +Add additional encodings: Korean (JOHAB), Thai (WIN874), Vietnamese (TCVN), Arabic (WIN1256), Simplified Chinese (GBK), Korean (UHC) (Eiji Tokuya) Enable locale support by default (Peter) @@ -545,7 +562,7 @@ Allow recursive SQL function (Peter) Change PL/Tcl build to use configured compiler and Makefile.shlib (Peter) Overhaul the PL/pgSQL FOUND variable to be more Oracle-compatible - (Tom, Neil) + (Neil, Tom) Allow PL/pgSQL to handle quoted identifiers (Tom) Allow set-returning PL/pgSQL functions (Neil) Make PL/pgSQL schema-aware (Joe) @@ -711,7 +728,7 @@ Improve /contrib/pgbench (Neil) Add /contrib/tablefunc table function examples (Joe) Add /contrib/ltree data type for tree structures (Teodor Sigaev, Oleg Bartunov) -Move /contrib/pg_controldata into main tree (Bruce) +Move /contrib/pg_controldata, pg_resetxlog into main tree (Bruce) Fixes to /contrib/cube (Bruno Wolff) Improve /contrib/fulltextindex (Christopher) -- 2.39.5