Received: from localhost (unknown [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 1BDAA2E014D; Wed, 28 Nov 2007 17:03:38 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 85069-05; Wed, 28 Nov 2007 17:03:28 -0400 (AST) Received: from lists.commandprompt.com (host-159.commandprompt.net [207.173.203.159]) by postgresql.org (Postfix) with ESMTP id 762482E0132; Wed, 28 Nov 2007 17:03:31 -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 lASL3SEK019021 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO); Wed, 28 Nov 2007 13:03:29 -0800 Date: Wed, 28 Nov 2007 13:03:42 -0800 From: "Joshua D. Drake" To: David Fetter Cc: Tom Lane , PostgreSQL Docs , PostgreSQL Patches Subject: Re: [PATCHES] Partition: use triggers instead of rules Message-ID: <20071128130342.08230616@commandprompt.com> In-Reply-To: <20071128205710.GL24146@fetter.org> References: <20071128202615.GG24146@fetter.org> <21686.1196283184@sss.pgh.pa.us> <20071128205710.GL24146@fetter.org> 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 13:03:30 -0800 (PST) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200711/111 X-Sequence-Number: 4644 LS0tLS1CRUdJTiBQR1AgU0lHTkVEIE1FU1NBR0UtLS0tLQ0KSGFzaDogU0hBMQ0KDQpPbiBXZWQs IDI4IE5vdiAyMDA3IDEyOjU3OjEwIC0wODAwDQpEYXZpZCBGZXR0ZXIgPGRhdmlkQGZldHRlci5v cmc+IHdyb3RlOg0KDQo+IE9uIFdlZCwgTm92IDI4LCAyMDA3IGF0IDAzOjUzOjA0UE0gLTA1MDAs IFRvbSBMYW5lIHdyb3RlOg0KPiA+IERhdmlkIEZldHRlciA8ZGF2aWRAZmV0dGVyLm9yZz4gd3Jp dGVzOg0KPiA+ID4gQmVzdCBwcmFjdGljZXMgZm9yIHBhcnRpdGlvbmluZyBzbyBmYXIgaGF2ZSBz aG93biB0aGF0IFRSSUdHRVJzDQo+ID4gPiBhcmUgYmV0dGVyIHRoYW4gUlVMRXMgZm9yIG1vc3Qg Y2FzZXMuICBQbGVhc2UgZmluZCBhdHRhY2hlZCBhDQo+ID4gPiBwYXRjaCB3aGljaCByZWZsZWN0 cyB0aGlzLg0KPiA+IA0KPiA+IEVudGlyZWx5IHJlbW92aW5nIHRoZSBleGFtcGxlIG9mIGhvdyB0 byBkbyBpdCB3aXRoIHJ1bGVzIGRvZXNuJ3QNCj4gPiBzZWVtIGxpa2UgYSBnb29kIGlkZWEuDQo+ IA0KPiBJdCBkb2VzIHRvIG1lLiAgSSBoYXZlbid0IGZvdW5kIGEgY2FzZSB5ZXQgd2hlcmUgcnVs ZXMgd29ya2VkIGV2ZW4gYXMNCj4gd2VsbCBhcyB0cmlnZ2Vycy4NCg0KSSBoYXZlIHlldCB0byBz ZWUgYSBwbGFjZSB0aGF0IHJ1bGVzIGFyZSBhcHByb3ByaWF0ZSBhdCBhbGwgd2l0aA0KcGFydGl0 aW9uaW5nLiBUaGUgb25seSBoYWxmIHJlYXNvbmFibGUgYXJndW1lbnQgdG8gdGhlaXIgZXhpc3Rl bmNlIHdpdGgNCml0IGlzIHRoYXQgdGhleSBhcmUgZWFzaWVyIGZvciBzb21lb25lIHdpdGggYW4g ZXh0cmVtZWx5IHNpbXBsZQ0KcGFydGl0aW9uaW5nIGNvbmZpZ3VyYXRpb24uDQoNCkhvd2V2ZXIg cnVsZXMgYXJlIHNvIGRlZmljaWVudCBvbiBhbnl0aGluZyBleGNlcHQgdGhlIGFic29sdXRlIG1v c3QNCmJhc2ljIGV4YW1wbGUgb2YgcGFydGl0aW9uaW5nIHRoYXQgSSB0aGluayB3ZSBhcmUgZG9p bmcgb3VyIG5ldw0KcGFydGl0aW9uaW5nIHVzZXJzIGEgZGlzc2VydmljZSBieSBzdGF0aW5nIGFu eXRoaW5nIGFib3V0IHJ1bGVzIGV4Y2VwdA0KaW4gcGFzc2luZy4NCg0KU2luY2VyZWx5LA0KDQpK b3NodWEgRC4gRHJha2UNCg0KPiANCj4gQ2hlZXJzLA0KPiBEYXZpZC4NCg0KDQotIC0tIA0KDQog ICAgICA9PT0gVGhlIFBvc3RncmVTUUwgQ29tcGFueTogQ29tbWFuZCBQcm9tcHQsIEluYy4gPT09 DQpTYWxlcy9TdXBwb3J0OiArMS41MDMuNjY3LjQ1NjQgICAyNHg3L0VtZXJnZW5jeTogKzEuODAw LjQ5Mi4yMjQwDQpQb3N0Z3JlU1FMIHNvbHV0aW9ucyBzaW5jZSAxOTk3ICBodHRwOi8vd3d3LmNv bW1hbmRwcm9tcHQuY29tLw0KCQkJVU5JUVVFIE5PVCBOVUxMDQpEb25hdGUgdG8gdGhlIFBvc3Rn cmVTUUwgUHJvamVjdDogaHR0cDovL3d3dy5wb3N0Z3Jlc3FsLm9yZy9hYm91dC9kb25hdGUNClBv c3RncmVTUUwgUmVwbGljYXRpb246IGh0dHA6Ly93d3cuY29tbWFuZHByb21wdC5jb20vcHJvZHVj dHMvDQoNCi0tLS0tQkVHSU4gUEdQIFNJR05BVFVSRS0tLS0tDQpWZXJzaW9uOiBHbnVQRyB2MS40 LjYgKEdOVS9MaW51eCkNCg0KaUQ4REJRRkhUZGV1QVRiL3pxZlpVVVFSQXZmM0FKOTZlNFl5blov cll2NmVnRyt3Kzg1TXMraWhvZ0NnaklsaA0KNnhXUjBuemNlb0pZQ2lRbCtmZkZUSzg9DQo9WFJF UA0KLS0tLS1FTkQgUEdQIFNJR05BVFVSRS0tLS0tDQo=