On Tue, 2008-09-16 at 00:37 +0000, michael McMaster wrote:
> I intend on creating a view over a large number of tables (possibly > 1000).
> Each table in the view has a CHECK constraint that partitions the data by a
> time range.
You may try using the inheritance mechanism rather than a UNION ALL
view.
Regards,
Jeff Davis