Re: SELECT results in "ERROR: index key does not match expected index column"

Поиск
Список
Период
Сортировка
От Andrew Gierth
Тема Re: SELECT results in "ERROR: index key does not match expected index column"
Дата
Msg-id 87tvc3q1ob.fsf@news-spur.riddles.org.uk
обсуждение исходный текст
Ответ на Re: SELECT results in "ERROR: index key does not match expected index column"  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: SELECT results in "ERROR: index key does not match expected index column"  (Manuel Rigger <rigger.manuel@gmail.com>)
Список pgsql-bugs
Дерево обсуждения 
>>>>> "Tom" == Tom Lane <tgl@sss.pgh.pa.us> writes:

 Tom> (You realize of course that an index on a constant is pretty
 Tom> useless. I wonder if we should disallow that.)

Unique index on a constant is a standard technique for forcing a table
to be limited to at most one row (or with a partial index, at most one
row matching a condition). Non-unique index on a constant is probably
not useful though.

-- 
Andrew (irc:RhodiumToad)

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Peter Geoghegan
Дата:
Сообщение: Re: SELECT results in "ERROR: index key does not match expected index column"
Следующее
От: PG Bug reporting form
Дата:
Сообщение: BUG #15887: An extra "break" instruction causes a bug