Re: Plans for partitioning of inheriting tables

Thanks, I shall have a look into it. I was under the assumption the
the create table like would create no more than a structural copy.

Torsten F��rtsch <tfoertsch123(at)gmail(dot)com> escribi��:

> Thiemo, ��
> it looks to me like you are using inheritance just to make sure
> your SOURCES and TOPO_FILES tables have some common columns. If you
> are not actually querying the TEMPLATE_TECH table and expect to see
> all the rows from the other 2 tables in that one table combined,
> then you could use CREATE TABLE (LIKE ...) instead of inheritance.
> That way your "child" tables would become normal tables and you
> could use declarative partitioning on them.
> ��
> Even if you are querying the TEMPLATE_TECH table, you could still
> do that by turning the TEMPLATE_TECH table into a view which
> performs a UNION ALL over the other tables.