Re: Two rules on a view do not like each other :-(

From: Dima Tkach <dmitry(at)openratings(dot)com>
To: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>
Cc: pg_general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Two rules on a view do not like each other :-(
Date: 2003-11-21 22:03:08
Message-ID: 3FBE8B9C.7060200@openratings.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Stephan Szabo wrote:

>As a side note, you might just want to write one rule with two actions to
>do this because that gets you whatever ordering you want by ordering the
>actions.
>
>
Yeah... I know. This was just a test example. In real life, I have two
different delete rules with different conditions (mutually exclusive),
and one unconditional rule, that actually inserts the new row...

Thanks for your help with that ordering problem though!
I changed the name of my rules and it now works just fine.
Do you guys have any plans to change it again in the future?

Also, have anything similar been done in 7.3 regarding the order in
which *triggers* are executed.
I know that in 7.2.4 the order was oficcially undefined, but they were
actually getting executed in the reversed creation order (the trigger
that was created more recently would get executed first).
Has that changed in 7.3 as well?

Thanks again for your help!

Dima

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Patrick Hatcher 2003-11-21 22:15:59 Re: Pg Dump error
Previous Message Tom Lane 2003-11-21 21:58:42 Re: ERROR: nodeRead: did not find '}' [x2]