From 85a366eb929865f6d64bbd0749d74dd7bd74e5e1 Mon Sep 17 00:00:00 2001 From: Bruce Momjian Date: Mon, 3 Oct 2005 02:21:16 +0000 Subject: [PATCH] Merge Tom and my descriptions of new sequence behavior into one entry. --- doc/src/sgml/release.sgml | 47 +++++++++++++++------------------------ 1 file changed, 18 insertions(+), 29 deletions(-) diff --git a/doc/src/sgml/release.sgml b/doc/src/sgml/release.sgml index f1d6086af9..dbe267876d 100644 --- a/doc/src/sgml/release.sgml +++ b/doc/src/sgml/release.sgml @@ -262,21 +262,6 @@ pg_[A-Za-z0-9_] - - - Add proper sequence function dependencies (Tom) - - - In previous releases, nextval(), - currval, and setval() recorded - sequence names as simple text strings, meaning that renaming or - dropping a sequence used in a DEFAULT made the - clause invalid. This release stores all newly-created sequence - function arguments using internal oids, allowing them to handle - sequence renaming, and adding dependency information that - - - add_missing_from is now false by default (Neil) @@ -408,22 +393,25 @@ pg_[A-Za-z0-9_] - Sequence arguments of nextval() and related functions - are now bound early by default (Tom) + Add proper sequence function dependencies for + DEFAULT clauses (Tom) + + + In previous releases, nextval(), + currval, and setval() recorded + sequence names as simple text strings, meaning that renaming or + dropping a sequence used in a DEFAULT made the + clause invalid. This release stores all newly-created sequence + function arguments using internal OIDs, allowing them to handle + sequence renaming, and adding dependency information that + prevents improper sequence removal. It also makes + DEFAULT clauses immune to schema search + path changes. - When an expression like nextval('myseq') appears in a - column DEFAULT expression or view, the referenced - sequence (here myseq) is now looked up immediately, - and its pg_class OID is placed in the stored expression. This - representation will survive renaming of the referenced sequence, - as well as changes in schema search paths. The system also - understands that the sequence reference represents a dependency, - so the sequence cannot be dropped without dropping the - referencing object. Previous releases stored this information as - a simple text string, with none of the benefits outlined above. - To get the old text-based behavior of run-time lookup of the - sequence name, cast the argument to text, for example + Some applications might rely on the old text-based behavior of + run-time lookup of the sequence name. This can still be done by + casting the argument to text, for example nextval('myseq'::text). @@ -13495,3 +13483,4 @@ sgml-local-catalogs:("/usr/lib/sgml/catalog") sgml-local-ecat-files:nil End: --> + -- 2.39.5