Re: Exclude constraint problem

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