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
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
