Received: from localhost (unknown [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id E9B272E3661; Wed, 28 Nov 2007 20:53:43 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 20660-01; Wed, 28 Nov 2007 20:53:32 -0400 (AST) Received: from fetter.org (start.fetter.org [66.92.188.65]) by postgresql.org (Postfix) with ESMTP id D9F712E3660; Wed, 28 Nov 2007 20:53:36 -0400 (AST) Received: by fetter.org (Postfix, from userid 500) id 73F44FBC8F8; Wed, 28 Nov 2007 16:53:34 -0800 (PST) Date: Wed, 28 Nov 2007 16:53:34 -0800 From: David Fetter To: Tom Lane Cc: PostgreSQL Docs , PostgreSQL Patches Subject: Re: Partition: use triggers instead of rules Message-ID: <20071129005334.GN24146@fetter.org> References: <20071128202615.GG24146@fetter.org> <21686.1196283184@sss.pgh.pa.us> <20071128205710.GL24146@fetter.org> <24889.1196288258@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <24889.1196288258@sss.pgh.pa.us> User-Agent: Mutt/1.5.17 (2007-11-01) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200711/117 X-Sequence-Number: 4650 On Wed, Nov 28, 2007 at 05:17:38PM -0500, Tom Lane wrote: > David Fetter writes: > > On Wed, Nov 28, 2007 at 03:53:04PM -0500, Tom Lane wrote: > >> Entirely removing the example of how to do it with rules doesn't > >> seem like a good idea. > > > It does to me. I haven't found a case yet where rules worked even > > as well as triggers. > > I don't have a problem with emphasizing triggers as the preferred > solution, but we should keep the older example, if only because > people are going to see DB schemas that use that approach, and they > won't understand what's going on (or realize they could convert) if > they've not seen an example. Greg Sabino Mullane managed to contrive an example where RULEs might conceivably be the least-bad way to do this, that being a machine where no PLs may be installed. Telling people how to do this is not *quite* as bad as describing how to do EAV, but it's pretty close. Cheers, David. -- David Fetter http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fetter@gmail.com Remember to vote! Consider donating to Postgres: http://www.postgresql.org/about/donate