Re: CONSTRAINT does not show when applying a EXCLUDE constraint

Поиск
Список
Период
Сортировка
От Richard Broersma
Тема Re: CONSTRAINT does not show when applying a EXCLUDE constraint
Дата
Msg-id AANLkTikyw1WUewcoNW0RWVRnJ3u712yQQ6KG+VXE1PVe@mail.gmail.com
обсуждение исходный текст
Ответ на Re: CONSTRAINT does not show when applying a EXCLUDE constraint  (InterRob <rob.marjot@gmail.com>)
Ответы Re: CONSTRAINT does not show when applying a EXCLUDE constraint  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: CONSTRAINT does not show when applying a EXCLUDE constraint  (Guillaume Lelarge <guillaume@lelarge.info>)
Список pgsql-general
Дерево обсуждения 
On Mon, Dec 27, 2010 at 12:50 PM, InterRob <rob.marjot@gmail.com> wrote:
> pgsql Command "\d test" produces the following:
>        Table "public.test"
>    Column   |  Type   | Modifiers
> ------------+---------+-----------
>  object_id  | integer |
>  subject_id | integer |
> Indexes:
>     "EXCL_double_combi" EXCLUDE USING btree (imm_least(subject_id,
> object_id) WITH =, imm_greatest(subject_id, object_id) WITH =)

I see.  Since exclusion constraints is a rather new feature, psql may
need some tweaking to report these constraints as constraints

--
Regards,
Richard Broersma Jr.

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

Предыдущее
От: InterRob
Дата:
Сообщение: Re: CONSTRAINT does not show when applying a EXCLUDE constraint
Следующее
От: Tom Lane
Дата:
Сообщение: Re: CONSTRAINT does not show when applying a EXCLUDE constraint