Hi Kevin,
From the PG documentation (section 5.8 - inheritance):
http://www.postgresql.org/docs/current/static/ddl-inherit.html
"A serious limitation of the inheritance feature is that indexes (including
unique constraints) and foreign key constraints only apply to single tables,
not to their
Hi all;
where's the best place for the indexes/constraints on a partitioned table.
I assume it's best to place the FK constraints/triggers on the base/master
table and the indexes on the individual partition tables.
Thoughts?
Thanks in advance.
--
Sent via pgsql-general mailing list (pgsql-g