Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commit11fbdf2

Browse files
committed
Update inheritance constraint items:
< o %Prevent child tables from altering or dropping constraints< like CHECK that were inherited from the parent table< like CHECK that are inherited by child tables<< Dropping constraints should only be possible with CASCADE.<> like CHECK that are inherited by child tables unless CASCADE> is used> o %Prevent child tables from altering or dropping constraints> like CHECK that were inherited from the parent table
1 parenta34fd95 commit11fbdf2

File tree

2 files changed

+10
-13
lines changed

2 files changed

+10
-13
lines changed

‎doc/TODO

Lines changed: 5 additions & 7 deletions
Original file line numberDiff line numberDiff line change
@@ -2,7 +2,7 @@
22
PostgreSQL TODO List
33
====================
44
Current maintainer:Bruce Momjian (pgman@candle.pha.pa.us)
5-
Last updated:Mon Apr 2420:26:45 EDT 2006
5+
Last updated:Mon Apr 2422:58:22 EDT 2006
66

77
The most recent version of this document can be viewed at
88
http://www.postgresql.org/docs/faqs.TODO.html.
@@ -499,13 +499,11 @@ SQL Commands
499499
Currently non-global system tables must be in the default database
500500
tablespace. Global system tables can never be moved.
501501

502-
o %Prevent child tables from altering or dropping constraints
503-
like CHECK that were inherited from the parent table
504502
o Prevent parent tables from altering or dropping constraints
505-
like CHECK that are inherited by child tables
506-
507-
Dropping constraints should only be possible with CASCADE.
508-
503+
like CHECK that are inherited by child tables unless CASCADE
504+
is used
505+
o %Prevent child tables from altering or dropping constraints
506+
like CHECK that were inherited from the parent table
509507
o Have ALTER INDEX update the name of a constraint using that index
510508
o Add ALTER TABLE RENAME CONSTRAINT, update index name also
511509

‎doc/src/FAQ/TODO.html

Lines changed: 5 additions & 6 deletions
Original file line numberDiff line numberDiff line change
@@ -8,7 +8,7 @@
88
<bodybgcolor="#FFFFFF"text="#000000"link="#FF0000"vlink="#A00000"alink="#0000FF">
99
<h1><aname="section_1">PostgreSQL TODO List</a></h1>
1010
<p>Current maintainer: Bruce Momjian (<ahref="mailto:pgman@candle.pha.pa.us">pgman@candle.pha.pa.us</a>)<br/>
11-
Last updated: Mon Apr 2420:26:45 EDT 2006
11+
Last updated: Mon Apr 2422:58:22 EDT 2006
1212
</p>
1313
<p>The most recent version of this document can be viewed at<br/>
1414
<ahref="http://www.postgresql.org/docs/faqs.TODO.html">http://www.postgresql.org/docs/faqs.TODO.html</a>.
@@ -458,12 +458,11 @@ <h1><a name="section_8">SQL Commands</a></h1>
458458
<p> Currently non-global system tables must be in the default database
459459
tablespace. Global system tables can never be moved.
460460
</p>
461-
</li><li>%Prevent child tables from altering or dropping constraints
462-
like CHECK that were inherited from the parent table
463461
</li><li>Prevent parent tables from altering or dropping constraints
464-
like CHECK that are inherited by child tables
465-
<p> Dropping constraints should only be possible with CASCADE.
466-
</p>
462+
like CHECK that are inherited by child tables unless CASCADE
463+
is used
464+
</li><li>%Prevent child tables from altering or dropping constraints
465+
like CHECK that were inherited from the parent table
467466
</li><li>Have ALTER INDEX update the name of a constraint using that index
468467
</li><li>Add ALTER TABLE RENAME CONSTRAINT, update index name also
469468
</li></ul>

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp