"Sriram Dandapani" <sdandapani@xxxxxxxxxxxxxxx> writes: > The jdbc inserts go into the main parent table and check constraints > redirect them to child tables. A check constraint can't redirect anything. Are you saying that you use a trigger to try to insert the row into *each* child table, relying on the constraints to make all except one insert fail? Ugh. You'd do a lot better to duplicate the partitioning-rule knowledge in the trigger, and do only one insert that should succeed --- no wasted cycles, and no need for a subtransaction. regards, tom lane
