From 24df49bd5a131d6e54df23e4c16251fee7e66c97 Mon Sep 17 00:00:00 2001 From: Bruce Momjian Date: Sat, 30 Jul 2005 03:18:38 +0000 Subject: [PATCH] Add: > * Allow SELECT ... FOR UPDATE on inherited tables --- doc/TODO | 3 ++- doc/src/FAQ/TODO.html | 3 ++- 2 files changed, 4 insertions(+), 2 deletions(-) diff --git a/doc/TODO b/doc/TODO index 6350187a7a..84905e7175 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: Fri Jul 29 23:15:58 EDT 2005 +Last updated: Fri Jul 29 23:18:30 EDT 2005 The most recent version of this document can be viewed at http://www.postgresql.org/docs/faqs.TODO.html. @@ -700,6 +700,7 @@ Indexes The main difficulty with this item is the problem of creating an index that can span more than one table. +* Allow SELECT ... FOR UPDATE on inherited tables * Add UNIQUE capability to non-btree indexes * -Use indexes for MIN() and MAX() diff --git a/doc/src/FAQ/TODO.html b/doc/src/FAQ/TODO.html index 97663415e5..ec0c3df59a 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: Fri Jul 29 23:15:58 EDT 2005 +Last updated: Fri Jul 29 23:18:30 EDT 2005

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

The main difficulty with this item is the problem of creating an index that can span more than one table.

+
  • Allow SELECT ... FOR UPDATE on inherited tables
  • Add UNIQUE capability to non-btree indexes
  • -Use indexes for MIN() and MAX()

    MIN/MAX queries can already be rewritten as SELECT col FROM tab ORDER -- 2.11.0