From 79222272bbace714af4f376fe2d8e0ce44dea61f Mon Sep 17 00:00:00 2001 From: Bruce Momjian Date: Mon, 28 Aug 2006 23:20:35 +0000 Subject: [PATCH] Update: < * Allow DEFERRABLE UNIQUE constraints? > * 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. > --- doc/TODO | 10 ++++++++-- doc/src/FAQ/TODO.html | 9 +++++++-- 2 files changed, 15 insertions(+), 4 deletions(-) diff --git a/doc/TODO b/doc/TODO index 2fc6ed3885..a9b86c0b4f 100644 --- a/doc/TODO +++ b/doc/TODO @@ -2,7 +2,7 @@ PostgreSQL TODO List ==================== Current maintainer: Bruce Momjian (bruce@momjian.us) -Last updated: Fri Aug 25 19:43:59 EDT 2006 +Last updated: Mon Aug 28 19:20:20 EDT 2006 The most recent version of this document can be viewed at http://www.postgresql.org/docs/faqs.TODO.html. @@ -873,7 +873,13 @@ Triggers memory. This could exhaust memory for very large trigger queues. This item involves dumping large queues into files. -* Allow DEFERRABLE UNIQUE constraints? +* 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 triggers to be disabled in only the current session. This is currently possible by starting a multi-statement transaction, diff --git a/doc/src/FAQ/TODO.html b/doc/src/FAQ/TODO.html index 826fc056ad..eee26db97b 100644 --- a/doc/src/FAQ/TODO.html +++ b/doc/src/FAQ/TODO.html @@ -8,7 +8,7 @@

PostgreSQL TODO List

Current maintainer: Bruce Momjian (bruce@momjian.us)
-Last updated: Fri Aug 25 19:43:59 EDT 2006 +Last updated: Mon Aug 28 19:20:20 EDT 2006

The most recent version of this document can be viewed at
http://www.postgresql.org/docs/faqs.TODO.html. @@ -794,7 +794,12 @@ first. memory. This could exhaust memory for very large trigger queues. This item involves dumping large queues into files.

Allow DEFERRABLE UNIQUE constraints? +

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 triggers to be disabled in only the current session.

This is currently possible by starting a multi-statement transaction, modifying the system tables, performing the desired SQL, restoring the -- 2.40.0