From ff3003e53704b6548473c94dc2d720fa87b2bed3 Mon Sep 17 00:00:00 2001 From: Bruce Momjian Date: Sun, 2 Jul 2006 01:59:46 +0000 Subject: [PATCH] Done: < o Add ALTER TABLE tab ADD/DROP INHERITS parent < < This allows tables to be added/removed from an inheritance < hierarchy. This is particularly useful for table partitioning. < http://archives.postgresql.org/pgsql-hackers/2006-05/msg00988.php < > o -Add ALTER TABLE tab INHERIT / NO INHERIT parent --- doc/TODO | 9 ++------- doc/src/FAQ/TODO.html | 8 ++------ 2 files changed, 4 insertions(+), 13 deletions(-) diff --git a/doc/TODO b/doc/TODO index 06391523d6..33e598d0d5 100644 --- a/doc/TODO +++ b/doc/TODO @@ -2,7 +2,7 @@ PostgreSQL TODO List ==================== Current maintainer: Bruce Momjian (bruce@momjian.us) -Last updated: Fri Jun 30 11:04:17 EDT 2006 +Last updated: Sat Jul 1 21:59:41 EDT 2006 The most recent version of this document can be viewed at http://www.postgresql.org/docs/faqs.TODO.html. @@ -565,12 +565,7 @@ SQL Commands is used o %Prevent child tables from altering or dropping constraints like CHECK that were inherited from the parent table - o Add ALTER TABLE tab ADD/DROP INHERITS parent - - This allows tables to be added/removed from an inheritance - hierarchy. This is particularly useful for table partitioning. - http://archives.postgresql.org/pgsql-hackers/2006-05/msg00988.php - + o -Add ALTER TABLE tab INHERIT / NO INHERIT parent o Have ALTER INDEX update the name of a constraint using that index o Add ALTER TABLE RENAME CONSTRAINT, update index name also diff --git a/doc/src/FAQ/TODO.html b/doc/src/FAQ/TODO.html index cca3e0d37d..1744230e9a 100644 --- a/doc/src/FAQ/TODO.html +++ b/doc/src/FAQ/TODO.html @@ -8,7 +8,7 @@

PostgreSQL TODO List

Current maintainer: Bruce Momjian (bruce@momjian.us)
-Last updated: Fri Jun 30 11:04:17 EDT 2006 +Last updated: Sat Jul 1 21:59:41 EDT 2006

The most recent version of this document can be viewed at
http://www.postgresql.org/docs/faqs.TODO.html. @@ -516,11 +516,7 @@ first. is used

%Prevent child tables from altering or dropping constraints like CHECK that were inherited from the parent table -

Add ALTER TABLE tab ADD/DROP INHERITS parent -

This allows tables to be added/removed from an inheritance - hierarchy. This is particularly useful for table partitioning. - http://archives.postgresql.org/pgsql-hackers/2006-05/msg00988.php -

-Add ALTER TABLE tab INHERIT / NO INHERIT parent

Have ALTER INDEX update the name of a constraint using that index

Add ALTER TABLE RENAME CONSTRAINT, update index name also

-- 2.40.0