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

Commit22bb692

Browse files
committed
Move to referential integrity section:
> o Allow DEFERRABLE and end-of-statement UNIQUE constraints?>> This would allow UPDATE tab SET col = col + 1 to work if col has> a unique index. Currently, uniqueness checks are done while the> command is being executed, rather than at the end of the statement> or transaction.><< * Allow DEFERRABLE and end-of-statement UNIQUE constraints?<< This would allow UPDATE tab SET col = col + 1 to work if col has< a unique index. Currently, uniqueness checks are done while the< command is being executed, rather than at the end of the statement< or transaction.
1 parent7922227 commit22bb692

File tree

2 files changed

+15
-15
lines changed

2 files changed

+15
-15
lines changed

‎doc/TODO

Lines changed: 8 additions & 8 deletions
Original file line numberDiff line numberDiff line change
@@ -2,7 +2,7 @@
22
PostgreSQL TODO List
33
====================
44
Current maintainer:Bruce Momjian (bruce@momjian.us)
5-
Last updated:Mon Aug 28 19:20:20 EDT 2006
5+
Last updated:Mon Aug 28 19:21:37 EDT 2006
66

77
The most recent version of this document can be viewed at
88
http://www.postgresql.org/docs/faqs.TODO.html.
@@ -683,6 +683,13 @@ SQL Commands
683683
http://archives.postgresql.org/pgsql-hackers/2005-09/msg00174.php
684684
http://archives.postgresql.org/pgsql-hackers/2005-09/msg00174.php
685685

686+
o Allow DEFERRABLE and end-of-statement UNIQUE constraints?
687+
688+
This would allow UPDATE tab SET col = col + 1 to work if col has
689+
a unique index. Currently, uniqueness checks are done while the
690+
command is being executed, rather than at the end of the statement
691+
or transaction.
692+
686693

687694
* Server-Side Languages
688695

@@ -873,13 +880,6 @@ Triggers
873880
memory. This could exhaust memory for very large trigger queues.
874881
This item involves dumping large queues into files.
875882

876-
* Allow DEFERRABLE and end-of-statement UNIQUE constraints?
877-
878-
This would allow UPDATE tab SET col = col + 1 to work if col has
879-
a unique index. Currently, uniqueness checks are done while the
880-
command is being executed, rather than at the end of the statement
881-
or transaction.
882-
883883
* Allow triggers to be disabled in only the current session.
884884

885885
This is currently possible by starting a multi-statement transaction,

‎doc/src/FAQ/TODO.html

Lines changed: 7 additions & 7 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:bruce@momjian.us">bruce@momjian.us</a>)<br/>
11-
Last updated: Mon Aug 28 19:20:20 EDT 2006
11+
Last updated: Mon Aug 28 19:21:37 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>.
@@ -618,6 +618,12 @@ <h1><a name="section_8">SQL Commands</a></h1>
618618
cascaded tables, seeing the tables in an intermediate state
619619
<p><ahref="http://archives.postgresql.org/pgsql-hackers/2005-09/msg00174.php">http://archives.postgresql.org/pgsql-hackers/2005-09/msg00174.php</a>
620620
<ahref="http://archives.postgresql.org/pgsql-hackers/2005-09/msg00174.php">http://archives.postgresql.org/pgsql-hackers/2005-09/msg00174.php</a>
621+
</p>
622+
</li><li>Allow DEFERRABLE and end-of-statement UNIQUE constraints?
623+
<p> This would allow UPDATE tab SET col = col + 1 to work if col has
624+
a unique index. Currently, uniqueness checks are done while the
625+
command is being executed, rather than at the end of the statement
626+
or transaction.
621627
</p>
622628
</li></ul>
623629
</li><li>Server-Side Languages
@@ -793,12 +799,6 @@ <h1><a name="section_10">Triggers</a></h1>
793799
<p> Right now all deferred trigger information is stored in backend
794800
memory. This could exhaust memory for very large trigger queues.
795801
This item involves dumping large queues into files.
796-
</p>
797-
</li><li>Allow DEFERRABLE and end-of-statement UNIQUE constraints?
798-
<p> This would allow UPDATE tab SET col = col + 1 to work if col has
799-
a unique index. Currently, uniqueness checks are done while the
800-
command is being executed, rather than at the end of the statement
801-
or transaction.
802802
</p>
803803
</li><li>Allow triggers to be disabled in only the current session.
804804
<p> This is currently possible by starting a multi-statement transaction,

0 commit comments

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