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:[EMAIL PROTECTED] Sent: Friday, September 29, 2006 2:48 PM To: Sriram Dandapani Cc: Matthew T. O'Connor; pgsql-admin@postgresql.org Subject: Re: [ADMIN] autovacuum ignore tables "Sriram Dandapani" <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
