From: | Gaetano Mendola <mendola(at)bigfoot(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Subject: | Re: Two rules on a view do not like each other :-( |
Date: | 2003-11-23 21:16:03 |
Message-ID: | 3FC12393.4060305@bigfoot.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Tom Lane wrote:
> Gaetano Mendola <mendola(at)bigfoot(dot)com> writes:
>
>>Tom Lane wrote:
>>
>>>Yes --- by name.
>
>
>>Why not implement in SQL standard way ?
>>I'm against this alphabetic order firing.
>
>
> You think order-of-creation has something to recommend it? I don't see
> what. It just makes it extremely painful to control the firing order
> when you need to --- you end up dropping and recreating all the
> triggers, which is a tedious and error-prone approach.
>
>
>>I's not safe develop a new trigger and completely change
>>the trigger firing order. Suppose that I want multiply for
>>2 a field of a table for each insert. What happen if that field
>>is manipulated already by another trigger calculating let me say:
>>sqrt ?
>
>
> You can equally easily run into similar problems with creation-order
> firing as well. There's no substitute for actually thinking about the
> interactions of multiple triggers on the same event...
Agreed but why don't follow the standard ?
Regards
Gaetano Mendola
From | Date | Subject | |
---|---|---|---|
Next Message | Alex Satrapa | 2003-11-23 22:20:39 | Mac OS X Shutdown Scripts? (was Re: Humor me: Postgresql vs. MySql (esp. licensing)) |
Previous Message | Tom Lane | 2003-11-23 20:32:52 | Re: Two rules on a view do not like each other :-( |