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

Commit84bb387

Browse files
committed
Update, add mention of user locking table before MERGE:
< so duplicate checking can be easily performed.> so duplicate checking can be easily performed. It is possible to> do it without a unique index if we require the user to LOCK the table> before the MERGE.
1 parentccdcd19 commit84bb387

File tree

2 files changed

+8
-4
lines changed

2 files changed

+8
-4
lines changed

‎doc/TODO

Lines changed: 4 additions & 2 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:Wed Nov 1611:33:25 EST 2005
5+
Last updated:Wed Nov 1613:44:51 EST 2005
66

77
The most recent version of this document can be viewed at
88
http://www.postgresql.org/docs/faqs.TODO.html.
@@ -373,7 +373,9 @@ SQL Commands
373373
triggers?)
374374

375375
To implement this cleanly requires that the table have a unique index
376-
so duplicate checking can be easily performed.
376+
so duplicate checking can be easily performed. It is possible to
377+
do it without a unique index if we require the user to LOCK the table
378+
before the MERGE.
377379

378380
* Add NOVICE output level for helpful messages like automatic sequence/index
379381
creation

‎doc/src/FAQ/TODO.html

Lines changed: 4 additions & 2 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: Wed Nov 1611:33:25 EST 2005
11+
Last updated: Wed Nov 1613:44:51 EST 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>.
@@ -342,7 +342,9 @@ <h1><a name="section_8">SQL Commands</a></h1>
342342
</li><li>Add MERGE command that does UPDATE/DELETE, or on failure, INSERT (rules,
343343
triggers?)
344344
<p> To implement this cleanly requires that the table have a unique index
345-
so duplicate checking can be easily performed.
345+
so duplicate checking can be easily performed. It is possible to
346+
do it without a unique index if we require the user to LOCK the table
347+
before the MERGE.
346348
</p>
347349
</li><li>Add NOVICE output level for helpful messages like automatic sequence/index
348350
creation

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp