Re: CONSTRAINT does not show when applying a EXCLUDE constraint - Mailing list pgsql-general

From Richard Broersma
Subject Re: CONSTRAINT does not show when applying a EXCLUDE constraint
Date
Msg-id AANLkTikyw1WUewcoNW0RWVRnJ3u712yQQ6KG+VXE1PVe@mail.gmail.com
Whole thread Raw
In response to Re: CONSTRAINT does not show when applying a EXCLUDE constraint  (InterRob <rob.marjot@gmail.com>)
Responses 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>)
List 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 by date:

Previous
From: InterRob
Date:
Subject: Re: CONSTRAINT does not show when applying a EXCLUDE constraint
Next
From: Tom Lane
Date:
Subject: Re: CONSTRAINT does not show when applying a EXCLUDE constraint