Re: Partition Views Again

There were several bugs in partition views, some of which become apparent only
when you use parallel qeuery.

One of the most significant bugs is in the manual, however. There is, in general, no
need to have an index on the partitioning columns: just imagine the case where
you partition a table on column X so that each table represents just one value for X -
when did you last index a column with only one 'different' value in it !

Given your comments about the complexitiy of the constraints (again, there is in
theory no obvious reason why you cannot have complex constraints), could you
post a sample of the constraint definition, and a sample of the query you expect
to use partitioning. Received on Sun Jun 01 1997 - 00:00:00 CDT