From 84bb3876bc6efad2c6b36198d6562797af6b0549 Mon Sep 17 00:00:00 2001 From: Bruce Momjian Date: Wed, 16 Nov 2005 18:45:09 +0000 Subject: [PATCH] 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. --- doc/TODO | 6 ++++-- doc/src/FAQ/TODO.html | 6 ++++-- 2 files changed, 8 insertions(+), 4 deletions(-) diff --git a/doc/TODO b/doc/TODO index 7974839352..8368334833 100644 --- a/doc/TODO +++ b/doc/TODO @@ -2,7 +2,7 @@ PostgreSQL TODO List ==================== Current maintainer: Bruce Momjian (pgman@candle.pha.pa.us) -Last updated: Wed Nov 16 11:33:25 EST 2005 +Last updated: Wed Nov 16 13:44:51 EST 2005 The most recent version of this document can be viewed at http://www.postgresql.org/docs/faqs.TODO.html. @@ -373,7 +373,9 @@ SQL Commands triggers?) To implement this cleanly requires that the table have a unique index - 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. * Add NOVICE output level for helpful messages like automatic sequence/index creation diff --git a/doc/src/FAQ/TODO.html b/doc/src/FAQ/TODO.html index fe0ad23c05..a3d1050c16 100644 --- a/doc/src/FAQ/TODO.html +++ b/doc/src/FAQ/TODO.html @@ -8,7 +8,7 @@

PostgreSQL TODO List

Current maintainer: Bruce Momjian (pgman@candle.pha.pa.us)
-Last updated: Wed Nov 16 11:33:25 EST 2005 +Last updated: Wed Nov 16 13:44:51 EST 2005

The most recent version of this document can be viewed at
http://www.postgresql.org/docs/faqs.TODO.html. @@ -342,7 +342,9 @@ first.

Add MERGE command that does UPDATE/DELETE, or on failure, INSERT (rules, triggers?)

To implement this cleanly requires that the table have a unique index - 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.

Add NOVICE output level for helpful messages like automatic sequence/index creation -- 2.40.0