I meant to say...rules are used on the parent table to redirect to child. Just like the way the postgres 8.1 documentation has it. -----Original Message----- From: Tom Lane [mailto:tgl@xxxxxxxxxxxxx] Sent: Friday, September 29, 2006 2:48 PM To: Sriram Dandapani Cc: Matthew T. O'Connor; pgsql-admin@xxxxxxxxxxxxxx Subject: Re: [ADMIN] autovacuum ignore tables "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
