Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 6C9D22E0115; Thu, 29 Nov 2007 13:13:58 -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 39718-05; Thu, 29 Nov 2007 13:13:37 -0400 (AST) Received: from lists.commandprompt.com (host-159.commandprompt.net [207.173.203.159]) by postgresql.org (Postfix) with ESMTP id A7AAC2E0102; Thu, 29 Nov 2007 13:13:46 -0400 (AST) Received: from localhost (or-69-34-217-90.sta.embarqhsd.net [69.34.217.90]) (authenticated bits=0) by lists.commandprompt.com (8.13.8/8.13.8) with ESMTP id lATHDdcv004455 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO); Thu, 29 Nov 2007 09:13:40 -0800 Date: Thu, 29 Nov 2007 09:13:59 -0800 From: "Joshua D. Drake" To: Gregory Stark Cc: "Tom Lane" , "Michael Paesold" , "NikhilS" , "David Fetter" , "Jonah H. Harris" , "PostgreSQL Docs" , "PostgreSQL Patches" Subject: Re: Partition: use triggers instead of rules Message-ID: <20071129091359.206fd8f2@commandprompt.com> In-Reply-To: <87zlwxj7xu.fsf@oxford.xeocode.com> References: <20071128202615.GG24146@fetter.org> <21686.1196283184@sss.pgh.pa.us> <36e682920711281858x9a37039sa104036bf025de41@mail.gmail.com> <20071129031702.GU24146@fetter.org> <2854.1196315753@sss.pgh.pa.us> <20071128224154.06f950c9@commandprompt.com> <474EDAE2.3010705@gmx.at> <474EE25E.3080304@commandprompt.com> <14455.1196353045@sss.pgh.pa.us> <474EE992.2050209@commandprompt.com> <87zlwxj7xu.fsf@oxford.xeocode.com> Organization: Command Prompt, Inc. X-Mailer: Claws Mail 3.0.2 (GTK+ 2.12.0; x86_64-pc-linux-gnu) Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: base64 X-Greylist: Sender succeeded SMTP AUTH, not delayed by milter-greylist-4.0 (lists.commandprompt.com [207.173.203.159]); Thu, 29 Nov 2007 09:13:40 -0800 (PST) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200711/130 X-Sequence-Number: 4663 LS0tLS1CRUdJTiBQR1AgU0lHTkVEIE1FU1NBR0UtLS0tLQ0KSGFzaDogU0hBMQ0KDQpPbiBUaHUs IDI5IE5vdiAyMDA3IDE3OjA4OjI5ICswMDAwDQpHcmVnb3J5IFN0YXJrIDxzdGFya0BlbnRlcnBy aXNlZGIuY29tPiB3cm90ZToNCg0KPiANCj4gIkpvc2h1YSBELiBEcmFrZSIgPGpkQGNvbW1hbmRw cm9tcHQuY29tPiB3cml0ZXM6DQo+IA0KPiA+IFRvbSBMYW5lIHdyb3RlOg0KPiA+DQo+ID4+ICBB IHRyaWdnZXIgd2lsbCBwcm9iYWJseSBiZWF0IGEgcnVsZSBmb3IgaW5zZXJ0cy91cGRhdGVzIGlu dm9sdmluZw0KPiA+PiBhIHNtYWxsIG51bWJlciBvZiByb3dzLg0KPiA+DQo+ID4gV2hpY2ggaXMg ZXhhY3RseSB3aGF0IHBhcnRpdGlvbmluZyBpcyBkb2luZy4NCj4gDQo+IFNheSB3aGF0Pw0KDQpI ZWgsIG8uay4gdGhhdCB3YXMgYW4gYW1iaWd1b3VzIHNlbnRlbmNlLiBJbiBhIHBhcnRpdGlvbmVk IGVudmlyb25tZW50DQp5b3UgYXJlIGxpa2VseSBub3QgbW92aW5nIG1pbGxpb25zIG9mIHJvd3Mg YXJvdW5kLiBUaHVzIHRoZSAicnVsZSINCmJlbmVmaXQgaXMgbG9zdC4gWW91IGFyZSBpbnN0ZWFk IHBlcmZvcm1pbmcgbWFueSAoc29tZXRpbWVzDQpsb3RzLW8tbWFueSkgaW5zZXJ0cyBhbmQgdXBk YXRlcyB0aGF0IGludm9sdmUgYSBzbWFsbCBudW1iZXIgb2Ygcm93cy4NCg0KQSB0cmlnZ2VyL2Z1 bmN0aW9uIGFzIFRvbSBhbHJlYWR5IHBvaW50ZWQgb3V0IGlzIGdvaW5nIHRvIHBlcmZvcm0gYmV0 dGVyDQp0aGFuIGEgcnVsZSBpbiB0aGF0IGNhc2UuIFRoZSBiZW5lZml0IGJlY29tZXMgZXZlbiBt b3JlIHByb25vdW5jZSB0aGUNCm1vcmUgcGFydGl0aW9ucyB5b3UgaGF2ZS4NCg0KU2luY2VyZWx5 LA0KDQpKb3NodWEgRC4gRHJha2UNCg0KDQotIC0tIA0KDQogICAgICA9PT0gVGhlIFBvc3RncmVT UUwgQ29tcGFueTogQ29tbWFuZCBQcm9tcHQsIEluYy4gPT09DQpTYWxlcy9TdXBwb3J0OiArMS41 MDMuNjY3LjQ1NjQgICAyNHg3L0VtZXJnZW5jeTogKzEuODAwLjQ5Mi4yMjQwDQpQb3N0Z3JlU1FM IHNvbHV0aW9ucyBzaW5jZSAxOTk3ICBodHRwOi8vd3d3LmNvbW1hbmRwcm9tcHQuY29tLw0KCQkJ VU5JUVVFIE5PVCBOVUxMDQpEb25hdGUgdG8gdGhlIFBvc3RncmVTUUwgUHJvamVjdDogaHR0cDov L3d3dy5wb3N0Z3Jlc3FsLm9yZy9hYm91dC9kb25hdGUNClBvc3RncmVTUUwgUmVwbGljYXRpb246 IGh0dHA6Ly93d3cuY29tbWFuZHByb21wdC5jb20vcHJvZHVjdHMvDQoNCi0tLS0tQkVHSU4gUEdQ IFNJR05BVFVSRS0tLS0tDQpWZXJzaW9uOiBHbnVQRyB2MS40LjYgKEdOVS9MaW51eCkNCg0KaUQ4 REJRRkhUdk5YQVRiL3pxZlpVVVFSQXFlSkFKOUNvTzZGNHpZSndZNGdlQVIxVXN2VkNZcWFnd0Nk RkptOQ0KNjNHUmtzcHBBVHA3Zks5cXUyUllYRDA9DQo9VnVXeQ0KLS0tLS1FTkQgUEdQIFNJR05B VFVSRS0tLS0tDQo=