Francisco Reyes wrote:
> I had the foreign key in the master table instead of the children.
> Deleted RI from master table and put into the inherited partitions.
> My whole 230 million rows merged in about an hour!
Heh -- but are the FKs now checked? Try inserting something that
violates the constraints and see if they are rejected.
--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support