How to add an exclude constraint with an existing index with specified operator?

Question

Assuming the following index:

CREATE INDEX CONCURRENTLY blocked_date_idx_on_since_until_range
  ON blocked_date
  USING gist(
    tstzrange(
      "blocked_since",
      "blocked_until",
      '[]'
    )
  );

Which is a range on 2 dates, I'd like to:

ALTER TABLE blocked_date
  ADD CONSTRAINT blocked_date_since_until_overlap
  EXCLUDE
    USING INDEX blocked_date_idx_on_since_until_range WITH &&;

This syntax is not valid (I get an error), but I can't find a valid one where I can specify which operator to use on the index. What is the right syntax for the ALTER TABLE part?

Francesco Belladonna · Accepted Answer · 2018-07-11 06:52:56Z

4

Currently there is no syntax to achieve this. You are required to create the constraint directly and can't create the index upfront.

answered Jul 11, 2018 at 6:52

Francesco Belladonna

11.8k14 gold badges83 silver badges152 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to add an exclude constraint with an existing index with specified operator?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related