Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 691642E0066; Thu, 29 Nov 2007 02:42:06 -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 35997-06-2; Thu, 29 Nov 2007 02:41:57 -0400 (AST) Received: from lists.commandprompt.com (host-159.commandprompt.net [207.173.203.159]) by postgresql.org (Postfix) with ESMTP id 0AAEF2E2DE3; Thu, 29 Nov 2007 02:41:58 -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 lAT6fi3t001507 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO); Wed, 28 Nov 2007 22:41:45 -0800 Date: Wed, 28 Nov 2007 22:41:54 -0800 From: "Joshua D. Drake" To: Tom Lane Cc: David Fetter , "Jonah H. Harris" , PostgreSQL Docs , PostgreSQL Patches Subject: Re: [PATCHES] Partition: use triggers instead of rules Message-ID: <20071128224154.06f950c9@commandprompt.com> In-Reply-To: <2854.1196315753@sss.pgh.pa.us> 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> 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]); Wed, 28 Nov 2007 22:41:45 -0800 (PST) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200711/123 X-Sequence-Number: 4656 LS0tLS1CRUdJTiBQR1AgU0lHTkVEIE1FU1NBR0UtLS0tLQ0KSGFzaDogU0hBMQ0KDQpPbiBUaHUs IDI5IE5vdiAyMDA3IDAwOjU1OjUzIC0wNTAwDQpUb20gTGFuZSA8dGdsQHNzcy5wZ2gucGEudXM+ IHdyb3RlOg0KDQo+IERhdmlkIEZldHRlciA8ZGF2aWRAZmV0dGVyLm9yZz4gd3JpdGVzOg0KPiA+ IE9uIFdlZCwgTm92IDI4LCAyMDA3IGF0IDA5OjU4OjI2UE0gLTA1MDAsIEpvbmFoIEguIEhhcnJp cyB3cm90ZToNCj4gPj4gT24gTm92IDI4LCAyMDA3IDM6NTMgUE0sIFRvbSBMYW5lIDx0Z2xAc3Nz LnBnaC5wYS51cz4gd3JvdGU6DQo+ID4+PiBFbnRpcmVseSByZW1vdmluZyB0aGUgZXhhbXBsZSBv ZiBob3cgdG8gZG8gaXQgd2l0aCBydWxlcyBkb2Vzbid0DQo+ID4+PiBzZWVtIGxpa2UgYSBnb29k IGlkZWEuDQo+ID4+IA0KPiA+PiBBZ3JlZWQuDQo+IA0KPiA+IERvIHlvdSBoYXZlIGFuIGV4YW1w bGUgb2Ygb25lIHVzZSBjYXNlIHdoZXJlIHVzaW5nIFJVTEVzIHJhdGhlciB0aGFuDQo+ID4gVFJJ R0dFUnMgaXMgYSBnb29kIGlkZWE/DQo+IA0KPiBUaGUgYXJndW1lbnQgSSBtYWRlIGZvciBrZWVw aW5nIHRoZSBleGFtcGxlIGFyb3VuZCBpcyBub3QgZGVwZW5kZW50IG9uDQo+IHRoZSBhc3N1bXB0 aW9uIHRoYXQgdXNpbmcgYSBydWxlIGlzIGEgZ29vZCBpZGVhLiAgSXQncyBkZXBlbmRlbnQgb24N Cj4gdGhlIGVzdGFibGlzaGVkIGZhY3QgdGhhdCB3ZSBoYXZlIHJlY29tbWVuZGVkIHRoYXQgaW4g cHJpb3IgcmVsZWFzZXMsDQo+IGFuZCB0aGVyZWZvcmUgcGVvcGxlIGFyZSBnb2luZyB0byBiZSBz ZWVpbmcgdGhhdCBjb25zdHJ1Y3QgaW4gcmVhbA0KPiBkYXRhYmFzZXMuDQoNCkFuZCB0aGV5IGNv dWxkIHJlZmVyIGJhY2sgdG8gdGhlIG9sZGVyIHZlcnNpb24gb2YgdGhlIGRvY3VtZW50YXRpb24g Zm9yDQppdC4gSW4gZmFjdCwgd2Ugc2hvdWxkIG1lbnRpb24gdGhhdCBpbiB0aGUgcGF0Y2g6DQoN Cjxub3RlPjxwYXJhPklmIHlvdSBoYXZlIGFuIHBhcnRpdGlvbmluZyBzZXR1cCB0aGF0IHVzZXMg cnVsZXMgcGxlYXNlDQpyZWZlciB0byB0aGUgOC4yIGRvY3VtZW50YXRpb24gb24gcGFydGl0aW9u aW5nPC9wYXJhPjwvbm90ZT4NCg0KU2luY2VyZWx5LA0KDQoNCkpvc2h1YSBELiBEcmFrZQ0KDQoN Cj4gDQo+IAkJCXJlZ2FyZHMsIHRvbSBsYW5lDQo+IA0KPiAtLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0oZW5kIG9mDQo+IGJyb2FkY2FzdCktLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0gVElQ IDQ6IEhhdmUgeW91IHNlYXJjaGVkIG91cg0KPiBsaXN0IGFyY2hpdmVzPw0KPiANCj4gICAgICAg ICAgICAgICAgaHR0cDovL2FyY2hpdmVzLnBvc3RncmVzcWwub3JnDQo+IA0KDQoNCi0gLS0gDQoN CiAgICAgID09PSBUaGUgUG9zdGdyZVNRTCBDb21wYW55OiBDb21tYW5kIFByb21wdCwgSW5jLiA9 PT0NClNhbGVzL1N1cHBvcnQ6ICsxLjUwMy42NjcuNDU2NCAgIDI0eDcvRW1lcmdlbmN5OiArMS44 MDAuNDkyLjIyNDANClBvc3RncmVTUUwgc29sdXRpb25zIHNpbmNlIDE5OTcgIGh0dHA6Ly93d3cu Y29tbWFuZHByb21wdC5jb20vDQoJCQlVTklRVUUgTk9UIE5VTEwNCkRvbmF0ZSB0byB0aGUgUG9z dGdyZVNRTCBQcm9qZWN0OiBodHRwOi8vd3d3LnBvc3RncmVzcWwub3JnL2Fib3V0L2RvbmF0ZQ0K UG9zdGdyZVNRTCBSZXBsaWNhdGlvbjogaHR0cDovL3d3dy5jb21tYW5kcHJvbXB0LmNvbS9wcm9k dWN0cy8NCg0KLS0tLS1CRUdJTiBQR1AgU0lHTkFUVVJFLS0tLS0NClZlcnNpb246IEdudVBHIHYx LjQuNiAoR05VL0xpbnV4KQ0KDQppRDhEQlFGSFRsODRBVGIvenFmWlVVUVJBdHNjQUo5aDc3bkRO SjNaZ2dXZ29jWERRYUZFL1M5OThnQ2NEdGlWDQp3S0gzQmVqc29MMGZSNUQzS0hoS2FFYz0NCj16 cFB2DQotLS0tLUVORCBQR1AgU0lHTkFUVVJFLS0tLS0NCg==