Guest User

Untitled

a guest
Mar 17th, 2018
83
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.41 KB | None | 0 0
  1. CREATE TYPE dow AS ENUM (
  2. 'Monday', 'Tuesday', 'Wednesday', 'Thursday',
  3. 'Friday', 'Saturday', 'Sunday'
  4. );
  5.  
  6. CREATE TABLE available (
  7. dow dow,
  8. tsrange tsrange,
  9. EXCLUDE USING gist (tsrange WITH =, dow WITH &&)
  10. );
  11.  
  12. ERROR: data type dow has no default operator class for access method "gist"
  13. HINT: You must specify an operator class for the index or define a default operator class for the data type.
Add Comment
Please, Sign In to add comment