Re: [DOCS] Partition: use triggers instead of rules - Mailing list pgsql-patches

From David Fetter
Subject Re: [DOCS] Partition: use triggers instead of rules
Date
Msg-id 20071129005334.GN24146@fetter.org
Whole thread Raw
In response to Re: [DOCS] Partition: use triggers instead of rules  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: [DOCS] Partition: use triggers instead of rules
List pgsql-patches
On Wed, Nov 28, 2007 at 05:17:38PM -0500, Tom Lane wrote:
> David Fetter <david@fetter.org> 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 <david@fetter.org> 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

pgsql-patches by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: proposed patch for function parameters name refs
Next
From: Alvaro Herrera
Date:
Subject: Re: [DOCS] Partition: use triggers instead of rules