Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 7B3B22E3735; Thu, 29 Nov 2007 13:52:29 -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 27956-05; Thu, 29 Nov 2007 13:52:14 -0400 (AST) Received: from lists.commandprompt.com (host-159.commandprompt.net [207.173.203.159]) by postgresql.org (Postfix) with ESMTP id AC8232E33D2; Thu, 29 Nov 2007 13:52:24 -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 lATHqG7I005604 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO); Thu, 29 Nov 2007 09:52:16 -0800 Date: Thu, 29 Nov 2007 09:52:33 -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: [PATCHES] Partition: use triggers instead of rules Message-ID: <20071129095233.67f2b913@commandprompt.com> In-Reply-To: <87ve7lj6y8.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> <20071129091359.206fd8f2@commandprompt.com> <87ve7lj6y8.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:52:17 -0800 (PST) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200711/132 X-Sequence-Number: 4665 LS0tLS1CRUdJTiBQR1AgU0lHTkVEIE1FU1NBR0UtLS0tLQ0KSGFzaDogU0hBMQ0KDQpPbiBUaHUs IDI5IE5vdiAyMDA3IDE3OjI5OjUxICswMDAwDQpHcmVnb3J5IFN0YXJrIDxzdGFya0BlbnRlcnBy aXNlZGIuY29tPiB3cm90ZToNCg0KPiAiSm9zaHVhIEQuIERyYWtlIiA8amRAY29tbWFuZHByb21w dC5jb20+IHdyaXRlczoNCj4gDQo+ID4gSGVoLCBvLmsuIHRoYXQgd2FzIGFuIGFtYmlndW91cyBz ZW50ZW5jZS4gSW4gYSBwYXJ0aXRpb25lZA0KPiA+IGVudmlyb25tZW50IHlvdSBhcmUgbGlrZWx5 IG5vdCBtb3ZpbmcgbWlsbGlvbnMgb2Ygcm93cyBhcm91bmQuIFRodXMNCj4gPiB0aGUgInJ1bGUi IGJlbmVmaXQgaXMgbG9zdC4gWW91IGFyZSBpbnN0ZWFkIHBlcmZvcm1pbmcgbWFueQ0KPiA+IChz b21ldGltZXMgbG90cy1vLW1hbnkpIGluc2VydHMgYW5kIHVwZGF0ZXMgdGhhdCBpbnZvbHZlIGEg c21hbGwNCj4gPiBudW1iZXIgb2Ygcm93cy4NCj4gDQo+IEknbSBzdGlsbCBub3QgZm9sbG93aW5n IGF0IGFsbC4gSWYgeW91J3JlIHBhcnRpdGlvbmluZyBpdCdzIGJlY2F1c2UNCj4geW91IGhhdmUg YSAqbG90KiBvZiBkYXRhLiBJdCBkb2Vzbid0IHNheSBhbnl0aGluZyBhYm91dCB3aGF0IHlvdSdy ZQ0KDQpJZiB5b3UgaGF2ZSBsb3RzIG9mIGRhdGEgaXQgZG9lc24ndCBtZWFuIHlvdSBhcmUgbW9k aWZ5aW5nIGxvdHMgb2YNCmRhdGEuIEkgdG9vayBwZXJoYXBzIGluY29ycmVjdGx5IHdoYXQgdGds IHNhaWQgYXMgbW9kaWZ5aW5nIGxvdHMgb2YNCmRhdGEuIEUuZzsgSSBhbSBkb2luZyBhIGxhcmdl IHRyYW5zYWN0aW9uIHRoYXQgaXMgZ29pbmcgdG8NCmluc2VydC91cGRhdGUgNTAwIHRob3VzYW5k IHJvd3MuDQoNCkkgZG9uJ3QgdGhpbmsgYW55b25lIGhlcmUgKGdvb2QgbG9yZCBJIGhvcGUgbm90 KSB3b3VsZCBzYXkgdGhhdCBmaXJpbmcNCmEgdHJpZ2dlciBvdmVyIDUwMGsgcm93cyBpcyBmYXN0 LiBJbnN0ZWFkIHlvdSBzaG91bGQgbGlrZWx5IGp1c3Qgd29yayB0aGUgZGF0YQ0Kb3V0c2lkZSB0 aGUgcGFydGl0aW9uIGFuZCB0aGVuIG1vdmUgaXQgZGlyZWN0bHkgaW50byB0aGUgdGFyZ2V0DQpw YXJ0aXRpb24uDQoNCj4gZG9pbmcgd2l0aCB0aGF0IGRhdGEuIFBhcnRpdGlvbmluZyBpcyB1c2Vm dWwgZm9yIG1hbmFnaW5nIGxhcmdlDQo+IHF1YW50aXRpZXMgb2YgZGF0YSBmb3IgYm90aCBPTFRQ IGFuZCBEU1Mgc3lzdGVtcy4NCg0KQ2VydGFpbmx5LiBJIGFtIG5vdCByZWFsbHkgYXJndWluZyB0 aGF0IGFuZCBJIHdvdWxkIHRlbmQgdG8gYWdyZWUgdGhhdA0KSSBhbSBiZWluZyB2ZXJ5IGZvY3Vz ZWQgb24gbXkgYXJndW1lbnRzIGFib3V0IHBhcnRpdGlvbmluZy4gVG8gbWUgaXQgaXMNCm9idmlv dXMgdGhhdCB5b3UgZG9uJ3QgdXNlIHRyaWdnZXJzIG9yIHJ1bGVzIHdoZW4gbW92aW5nIHRvbnMg b2YgZGF0YSwNCmVpdGhlciBvbmUgaXMganVzdCBhIGJ1cmRlbiB5b3UgZG9uJ3QgbmVlZC4NCg0K UGFydGl0aW9uaW5nIGlzIGdlbmVyYWxseSBtb3N0IHVzZWZ1bCBmb3I6DQoNCkJyZWFraW5nIHVw IGxhcmdlIHRhYmxlcyBhbmQgaW5kZXhlcyBzbyB5b3UgYXJlIGRlYWxpbmcgd2l0aCBsZXNzIGRh dGENCm9uIGFjdGl2ZSBxdWVyaWVzLg0KDQpCcmVha2luZyB1cCBsYXJnZSB0YWJsZXMgc28geW91 IGRvbid0IGVuZCB1cCB2YWN1dW1pbmcgYXQgNTAwIG1pbGxpb24NCnJvdyB0YWJsZSB0aGF0IG9u bHkgMSBtaWxsaW9uIHJvd3MgYXJlIGV2ZXIgdXBkYXRlZC4NCg0KUm90YXRpbmcgb3V0IGhpZ2hs eSB1cGRhdGVkIGRhdGEgc28geW91IGNhbiBrZWVwIGJsb2F0IGRvd24gKEhPVA0KcmVzb2x2ZXMg dGhpcyBpbiBjZXJ0YWluIGNhc2VzKS4NCg0KR2VuZXJhbCBkYXRhIG1hbmFnZW1lbnQgb2YgbGFy Z2Ugc2V0cy4gQXJjaGl2ZXMgYW5kIHRoZSBsaWtlLg0KDQpJbiBhbnkgb2YgdGhlIGFib3ZlIGNh c2VzIGEgdHJpZ2dlciBpcyBnb2luZyB0byB3b3JrIGJldHRlciB0aGFuIGEgcnVsZQ0Kd2l0aCB0 aGUgZXhjZXB0aW9ucyBvZiB3aGF0IFRHTCBwb2ludGVkIG91dCBhbmQgaW4gc2ltcGxlcg0KcGFy dGl0aW9uaW5nIGVudmlyb25tZW50cyB3aGVyZSB0aGUgbnVtYmVyIG9mIHBhcnRpdGlvbnMgYXJl IHZlcnkgbG93Lg0KDQpFaXRoZXIgd2F5LCB0byBkcml2ZSB0aGlzIGJhY2sgdG8gdG9waWMgOiku LiBvbiB0aGUgZG9jcyBpZiB3ZSBrZWVwIHRoZQ0KcnVsZSBleGFtcGxlIGl0IHNob3VsZCBiZSBi ZWxvdyB0aGUgcGFydGl0aW9uZWQgZXhhbXBsZSBhbmQgd2UgbmVlZCB0bw0KbGlzdCBjYXZlYXRz IG9uIGJvdGguIFdoaWNoIEkgcGVyc29uYWxseSB0aGluayBpcyBvdmVya2lsbCBmb3INCnJlZmVy ZW5jZSBkb2N1bWVudGF0aW9uIGJ1dCBpdCBzZWVtcyB0byBiZSB3aGF0IHNvbWUgcGVvcGxlIHdh bnQuDQoNCj4gDQo+IEkgdGVuZCB0byBiZSBoYXBwaWVyIHJlY29tbWVuZGluZyB0cmlnZ2VycyBv dmVyIHJ1bGVzIGlmIG9ubHkgYmVjYXVzZQ0KPiBydWxlcyBhcmUganVzdCBoYXJkZXIgdG8gdW5k ZXJzdGFuZC4gQXJndWFibHkgdGhleSBkb24ndCByZWFsbHkgd29yaw0KPiBwcm9wZXJseSBmb3Ig dGhpcyB1c2UgYW55d2F5cyBnaXZlbiB3aGF0IGhhcHBlbnMgaWYgeW91IHVzZSB2b2xhdGlsZQ0K PiBmdW5jdGlvbnMgbGlrZSByYW5kb20oKSBpbiB5b3VyIHdoZXJlIGNsYXVzZS4NCj4gDQoNCm5v ZC4NCg0KU2luY2VyZWx5LA0KDQpKb3NodWEgRC4gRHJha2UNCg0KDQoNCi0gLS0gDQoNCiAgICAg ID09PSBUaGUgUG9zdGdyZVNRTCBDb21wYW55OiBDb21tYW5kIFByb21wdCwgSW5jLiA9PT0NClNh bGVzL1N1cHBvcnQ6ICsxLjUwMy42NjcuNDU2NCAgIDI0eDcvRW1lcmdlbmN5OiArMS44MDAuNDky LjIyNDANClBvc3RncmVTUUwgc29sdXRpb25zIHNpbmNlIDE5OTcgIGh0dHA6Ly93d3cuY29tbWFu ZHByb21wdC5jb20vDQoJCQlVTklRVUUgTk9UIE5VTEwNCkRvbmF0ZSB0byB0aGUgUG9zdGdyZVNR TCBQcm9qZWN0OiBodHRwOi8vd3d3LnBvc3RncmVzcWwub3JnL2Fib3V0L2RvbmF0ZQ0KUG9zdGdy ZVNRTCBSZXBsaWNhdGlvbjogaHR0cDovL3d3dy5jb21tYW5kcHJvbXB0LmNvbS9wcm9kdWN0cy8N Cg0KLS0tLS1CRUdJTiBQR1AgU0lHTkFUVVJFLS0tLS0NClZlcnNpb246IEdudVBHIHYxLjQuNiAo R05VL0xpbnV4KQ0KDQppRDhEQlFGSFR2eGtBVGIvenFmWlVVUVJBaFJ0QUtDSGNXQmhWWmdUTThY WHE4a0pXV21pMG00OWNBQ2dtQVU1DQp4cW9zVG82c0pQcXBNTUtXTnZvVFdHVT0NCj16RFV3DQot LS0tLUVORCBQR1AgU0lHTkFUVVJFLS0tLS0NCg==