Received: from localhost (unknown [200.46.204.184])
	by postgresql.org (Postfix) with ESMTP id 3E6592E0037
	for <pgsql-docs-postgresql.org@postgresql.org>;
	Sun,  2 Dec 2007 15:21:43 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024)
	with ESMTP id 53189-04 for <pgsql-docs-postgresql.org@postgresql.org>;
	Sun,  2 Dec 2007 15:21:38 -0400 (AST)
Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130])
	by postgresql.org (Postfix) with ESMTP id 8D6C42E0033
	for <pgsql-docs@postgresql.org>; Sun,  2 Dec 2007 15:21:40 -0400 (AST)
Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1])
	by sss.pgh.pa.us (8.14.1/8.14.1) with ESMTP id lB2JLVkx023126;
	Sun, 2 Dec 2007 14:21:31 -0500 (EST)
To: David Fetter <david@fetter.org>
cc: NikhilS <nikkhils@gmail.com>, Gregory Stark <stark@enterprisedb.com>,
	"Joshua D. Drake" <jd@commandprompt.com>,
	Michael Paesold <mpaesold@gmx.at>,
	"Jonah H. Harris" <jonah.harris@gmail.com>,
	PostgreSQL Docs <pgsql-docs@postgresql.org>,
	PostgreSQL Patches <pgsql-patches@postgresql.org>
Subject: Re: [PATCHES] Partition: use triggers instead of rules 
In-reply-to: <20071201045620.GW27157@fetter.org> 
References: <474EDAE2.3010705@gmx.at> <474EE25E.3080304@commandprompt.com>
	<14455.1196353045@sss.pgh.pa.us>
	<474EE992.2050209@commandprompt.com>
	<87zlwxj7xu.fsf@oxford.xeocode.com>
	<20071129091359.206fd8f2@commandprompt.com>
	<87ve7lj6y8.fsf@oxford.xeocode.com>
	<20071129095233.67f2b913@commandprompt.com>
	<87d4tser8g.fsf@oxford.xeocode.com>
	<d3c4af540711292304k7092335ete0470fd896bbb2ab@mail.gmail.com>
	<20071201045620.GW27157@fetter.org>
Comments: In-reply-to David Fetter <david@fetter.org>
	message dated "Fri, 30 Nov 2007 20:56:20 -0800"
Date: Sun, 02 Dec 2007 14:21:31 -0500
Message-ID: <23125.1196623291@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200712/3
X-Sequence-Number: 4671

David Fetter <david@fetter.org> writes:
> On Fri, Nov 30, 2007 at 12:34:05PM +0530, NikhilS wrote:
>> Another reason to go along with triggers is that "COPY" honors
>> triggers, but does not honor rules. While trying to do bulk inserts
>> into a parent of partitioned tables where rules are being employed,
>> the COPY operation will not be so straightforward.

> Does my latest patch attached address this well enough?

Applied with revisions and extensions.  (I take it you hadn't actually
tested the example :-()

			regards, tom lane