Re: unique, partitioned index fails to distinguish index key fromINCLUDEd columns

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: unique, partitioned index fails to distinguish index key fromINCLUDEd columns
Дата
Msg-id 201901142231.tbnjmhllnptv@alvherre.pgsql
обсуждение исходный текст
Ответ на unique, partitioned index fails to distinguish index key fromINCLUDEd columns  (Justin Pryzby <pryzby@telsasoft.com>)
Ответы Re: unique, partitioned index fails to distinguish index key fromINCLUDEd columns  (Justin Pryzby <pryzby@telsasoft.com>)
Список pgsql-hackers
On 2019-Jan-09, Justin Pryzby wrote:

> -- Fails to error
> postgres=# CREATE UNIQUE INDEX ON t(j) INCLUDE(i);
> 
> -- Fail to enforce uniqueness across partitions due to failure to enforce inclusion of partition key in index KEY
> postgres=# INSERT INTO t VALUES(1,1);
> postgres=# INSERT INTO t VALUES(2,1); 

Doh.  Fix pushed.  Commit 8224de4f42cc should have changed one
appearance of ii_NumIndexAttrs to ii_NumIndexKeyAttrs, but because of
the nature of concurrent development, nobody noticed.

Thanks for reporting.

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: hostorder and failover_timeout for libpq
Следующее
От: Andres Freund
Дата:
Сообщение: Re: [HACKERS] Surjective functional indexes