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

Commit2b21521

Browse files
committed
Mark item as complete, add another:
< * Allow triggers to be disabled [trigger]> * -Allow triggers to be disabled [trigger]> * Allow triggers to be disabled in only the current session.< Currently the only way to disable triggers is to modify the system< tables.> This is currently possible by starting a multi-statement transaction,> modifying the system tables, performing the desired SQL, restoring the> system tables, and committing the transaction. ALTER TABLE ...> TRIGGER requires a table lock so it is not idea for this usage.
1 parent5279f68 commit2b21521

File tree

2 files changed

+14
-8
lines changed

2 files changed

+14
-8
lines changed

‎doc/TODO‎

Lines changed: 7 additions & 4 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:Sat Aug20 21:04:41 EDT 2005
5+
Last updated:Tue Aug23 19:51:09 EDT 2005
66

77
The most recent version of this document can be viewed at
88
http://www.postgresql.org/docs/faqs.TODO.html.
@@ -638,10 +638,13 @@ Referential Integrity
638638
* Change foreign key constraint for array -> element to mean element
639639
in array?
640640
* Allow DEFERRABLE UNIQUE constraints?
641-
* Allow triggers to be disabled [trigger]
641+
* -Allow triggers to be disabled [trigger]
642+
* Allow triggers to be disabled in only the current session.
642643

643-
Currently the only way to disable triggers is to modify the system
644-
tables.
644+
This is currently possible by starting a multi-statement transaction,
645+
modifying the system tables, performing the desired SQL, restoring the
646+
system tables, and committing the transaction. ALTER TABLE ...
647+
TRIGGER requires a table lock so it is not idea for this usage.
645648

646649
* With disabled triggers, allow pg_dump to use ALTER TABLE ADD FOREIGN KEY
647650

‎doc/src/FAQ/TODO.html‎

Lines changed: 7 additions & 4 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:Sat Aug20 21:04:41 EDT 2005
11+
Last updated:Tue Aug23 19:51:09 EDT 2005
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>.
@@ -580,9 +580,12 @@ <h1><a name="section_10">Referential Integrity</a></h1>
580580
</li><li>Change foreign key constraint for array -&gt; element to mean element
581581
in array?
582582
</li><li>Allow DEFERRABLE UNIQUE constraints?
583-
</li><li>Allow triggers to be disabled [<ahref="http://momjian.postgresql.org/cgi-bin/pgtodo?trigger">trigger</a>]
584-
<p> Currently the only way to disable triggers is to modify the system
585-
tables.
583+
</li><li>-<em>Allow triggers to be disabled [<ahref="http://momjian.postgresql.org/cgi-bin/pgtodo?trigger">trigger</a>]</em>
584+
</li><li>Allow triggers to be disabled in only the current session.
585+
<p> This is currently possible by starting a multi-statement transaction,
586+
modifying the system tables, performing the desired SQL, restoring the
587+
system tables, and committing the transaction. ALTER TABLE ...
588+
TRIGGER requires a table lock so it is not idea for this usage.
586589
</p>
587590
</li><li>With disabled triggers, allow pg_dump to use ALTER TABLE ADD FOREIGN KEY
588591
<p> If the dump is known to be valid, allow foreign keys to be added

0 commit comments

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