On Tuesday, May 21, 2013, Richard Onorato wrote: > I am wanting to partition my data based on a mod of one of the bigint > columns, but when I run my insert test all the data goes into the base > table and not the partitions. Here is what the table looks like: >
This works for me, on 9.2.4. Can you show exactly how you do the inserts? CREATE TABLE MyMappingTableT1 (PRIMARY KEY (id), CHECK((c1 % 5) = 0)) > INHERITS (MyMappingTable); > > This is not going to work well. constraint_exclusion does not understand the modulus operator. Cheers, Jeff
