Alex Zepeda <zipzippy(at)sonic(dot)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_time WITH &&, 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