Skip site navigation (1) Skip section navigation (2)

Re: [PATCHES] Partition: use triggers instead of rules

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: David Fetter <david(at)fetter(dot)org>
Cc: "Jonah H(dot) Harris" <jonah(dot)harris(at)gmail(dot)com>, PostgreSQL Docs <pgsql-docs(at)postgresql(dot)org>, PostgreSQL Patches <pgsql-patches(at)postgresql(dot)org>
Subject: Re: [PATCHES] Partition: use triggers instead of rules
Date: 2007-11-29 05:55:53
Message-ID: 2854.1196315753@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-docspgsql-patches
David Fetter <david(at)fetter(dot)org> writes:
> On Wed, Nov 28, 2007 at 09:58:26PM -0500, Jonah H. Harris wrote:
>> On Nov 28, 2007 3:53 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>>> Entirely removing the example of how to do it with rules doesn't
>>> seem like a good idea.
>> 
>> Agreed.

> Do you have an example of one use case where using RULEs rather than
> TRIGGERs is a good idea?

The argument I made for keeping the example around is not dependent on
the assumption that using a rule is a good idea.  It's dependent on the
established fact that we have recommended that in prior releases, and
therefore people are going to be seeing that construct in real
databases.

			regards, tom lane

In response to

Responses

pgsql-docs by date

Next:From: Jeremy DrakeDate: 2007-11-29 06:23:41
Subject: Re: [DOCS] Partition: use triggers instead of rules
Previous:From: David FetterDate: 2007-11-29 03:17:02
Subject: Re: [PATCHES] Partition: use triggers instead of rules

pgsql-patches by date

Next:From: Tom LaneDate: 2007-11-29 06:09:50
Subject: Re: Re: [HACKERS] [GENERAL] plperl and regexps with accented characters - incompatible?
Previous:From: Andrew DunstanDate: 2007-11-29 05:39:30
Subject: Re: [HACKERS] [GENERAL] plperl and regexps with accented characters - incompatible?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group