Re: [HACKERS] array exclusion constraints

2014-11-13 Thread Antonin Houska
franc...@hush.com wrote: > > CREATE TABLE test ( >foo text[], >EXCLUDE USING gist (foo WITH &&) > ); > > ERROR: data type text[] has no default operator class for access method > "gist" > HINT: You must specify an operator class for the index or define a default > operator class for t

[HACKERS] array exclusion constraints

2014-11-13 Thread francisk
CREATE TABLE test ( foo text[], EXCLUDE USING gist (foo WITH &&) ); ERROR: data type text[] has no default operator class for access method "gist" HINT: You must specify an operator class for the index or define a default operator class for the data type. It looks like exclusion constra