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

Commitebdc358

Browse files
committed
Add:
> o Prevent parent tables from altering or dropping constraints> like CHECK that are inherited by child tables>> Dropping constraints should only be possible with CASCADE.>
1 parent2abf8c7 commitebdc358

File tree

2 files changed

+11
-2
lines changed

2 files changed

+11
-2
lines changed

‎doc/TODO

Lines changed: 6 additions & 1 deletion
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 Mar 6 10:19:42 EST 2006
5+
Last updated:Mon Mar 612:10:25 EST 2006
66

77
The most recent version of this document can be viewed at
88
http://www.postgresql.org/docs/faqs.TODO.html.
@@ -471,6 +471,11 @@ SQL Commands
471471

472472
o %Prevent child tables from altering or dropping constraints
473473
like CHECK that were inherited from the parent table
474+
o Prevent parent tables from altering or dropping constraints
475+
like CHECK that are inherited by child tables
476+
477+
Dropping constraints should only be possible with CASCADE.
478+
474479
o Have ALTER INDEX update the name of a constraint using that index
475480
o Add ALTER TABLE RENAME CONSTRAINT, update index name also
476481

‎doc/src/FAQ/TODO.html

Lines changed: 5 additions & 1 deletion
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 Mar 6 10:19:42 EST 2006
11+
Last updated: Mon Mar 612:10:25 EST 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>.
@@ -433,6 +433,10 @@ <h1><a name="section_8">SQL Commands</a></h1>
433433
</p>
434434
</li><li>%Prevent child tables from altering or dropping constraints
435435
like CHECK that were inherited from the parent table
436+
</li><li>Prevent parent tables from altering or dropping constraints
437+
like CHECK that are inherited by child tables
438+
<p> Dropping constraints should only be possible with CASCADE.
439+
</p>
436440
</li><li>Have ALTER INDEX update the name of a constraint using that index
437441
</li><li>Add ALTER TABLE RENAME CONSTRAINT, update index name also
438442
</li></ul>

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp