From 150328cd61f5925df80fbf52f6f0208fa2c93a7e Mon Sep 17 00:00:00 2001 From: Bruce Momjian Date: Tue, 21 Nov 2006 03:44:55 +0000 Subject: [PATCH] I noticed that the Partitioning section of the docs has *two* sections of caveats in different places, but close together. One called caveats, one not. That looks like it just led to somebody not reading some appropriate caveats in the second group of caveats (on -admin). Simon Riggs --- doc/src/sgml/ddl.sgml | 64 +++++++++++++++++++++++++-------------------------- 1 file changed, 32 insertions(+), 32 deletions(-) diff --git a/doc/src/sgml/ddl.sgml b/doc/src/sgml/ddl.sgml index fbf4fda64b..8a3b2ebc7f 100644 --- a/doc/src/sgml/ddl.sgml +++ b/doc/src/sgml/ddl.sgml @@ -1,4 +1,4 @@ - + Data Definition @@ -2657,36 +2657,6 @@ ALTER TABLE measurement_y2006m02 INHERIT measurement; - - Caveats - - - The following caveats apply to partitioned tables: - - - - There is currently no way to verify that all of the - CHECK constraints are mutually - exclusive. Care is required by the database designer. - - - - - - There is currently no simple way to specify that rows must not be - inserted into the master table. A CHECK (false) - constraint on the master table would be inherited by all child - tables, so that cannot be used for this purpose. One possibility is - to set up an ON INSERT trigger on the master table that - always raises an error. (Alternatively, such a trigger could be - used to redirect the data into the proper child table, instead of - using a set of rules as suggested above.) - - - - - - Partitioning and Constraint Exclusion @@ -2768,9 +2738,39 @@ EXPLAIN SELECT count(*) FROM measurement WHERE logdate >= DATE '2006-01-01'; a large part of the partition or just a small part. An index will be helpful in the latter case but not the former. + + + + Caveats + + + The following caveats apply to partitioned tables: + + + + There is currently no way to verify that all of the + CHECK constraints are mutually + exclusive. Care is required by the database designer. + + + + + + There is currently no simple way to specify that rows must not be + inserted into the master table. A CHECK (false) + constraint on the master table would be inherited by all child + tables, so that cannot be used for this purpose. One possibility is + to set up an ON INSERT trigger on the master table that + always raises an error. (Alternatively, such a trigger could be + used to redirect the data into the proper child table, instead of + using a set of rules as suggested above.) + + + + - The following caveats apply: + The following caveats apply to constraint exclusion: -- 2.11.0