Re: Exclude constraint problem - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Exclude constraint problem
Date
Msg-id 20355.1283214083@sss.pgh.pa.us
Whole thread Raw
In response to Re: Exclude constraint problem  (Alex Zepeda <zipzippy@sonic.net>)
Responses Re: Exclude constraint problem  (Alex Zepeda <zipzippy@sonic.net>)
List pgsql-bugs
Alex Zepeda <zipzippy@sonic.net> writes:
> If I try to manually add the constraint on the table I get:
> blockface=# alter table bus_positions add constraint "exclude_time_buffer" EXCLUDE USING gist (vehicle WITH =,
buffer_timeWITH &&, bbox_dup WITH &&); 
> NOTICE:  ALTER TABLE / ADD EXCLUDE will create implicit index "exclude_time_buffer" for table "bus_positions"
> ERROR:  could not create exclusion constraint "exclude_time_buffer"

Try manually adding a similar constraint (ie, one redundant with the
existing one) on the source box.  Does it work?

            regards, tom lane

pgsql-bugs by date:

Previous
From: Jeff Davis
Date:
Subject: Re: Exclude constraint problem
Next
From: Alex Zepeda
Date:
Subject: Re: Exclude constraint problem