Re: [GENERAL] Constraint exclusion on tables partitioned over range types

2014-08-25 Thread Emanuel Calvo
2014-08-22 14:34 GMT-03:00 Daniele Varrazzo : > Hello, > > we are setting up a partitioned table based on tstzrange in PG 9.3, > something like: > > create table offer ( >during tstzrange not null, >... >constraint virtual check (false) no inherit >); > > create

[GENERAL] Constraint exclusion on tables partitioned over range types

2014-08-22 Thread Daniele Varrazzo
Hello, we are setting up a partitioned table based on tstzrange in PG 9.3, something like: create table offer ( during tstzrange not null, ... constraint virtual check (false) no inherit ); create table offer_201408 ( check (during <@ '[2014-08-01Z,2014-09