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