Create a deferrably-unique index

Поиск
Список
Период
Сортировка
От Paul Jungwirth
Тема Create a deferrably-unique index
Дата
Msg-id CA+6hpakfbvG4MVWD_UzQPUT8+NjkbqS1bvKRUTENz5pu77Vg3Q@mail.gmail.com
обсуждение исходный текст
Ответы Re: Create a deferrably-unique index  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
I'm trying to create a unique index where the unique constraint is
`deferrable initially immediate`. But I don't see any way to do this
in the syntax of the `create index` command. It looks like the only
way to do it is via `alter table foo add unique`. Is that right, or
can I do it as part of `create index`?

If I have to use `alter table add unique`, is there any way I can make
sure the implicitly-created index also has a `where` clause? Or is it
impossible to create an index that is unique + deferrable + partial?

Thank you,
Paul


--
_________________________________
Pulchritudo splendor veritatis.


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

Предыдущее
От: Vick Khera
Дата:
Сообщение: Re: please suggest i need to test my upgrade
Следующее
От: Granthana Biswas
Дата:
Сообщение: AccessShareLock on pg_authid