Re: Rules versus triggers

On 7/3/20 5:01 μ.μ., Justin wrote:
> Yes a rule can rewrite query or replace the query
>
> Read through Depesz  post about rules and the weird side affects that can occurr
> https://www.depesz.com/2010/06/15/to-rule-or-not-to-rule-that-is-the-question/
>
IMHO Rules are cool. It allows for more elegant design (vs doing it otherwise) and it results in faster queries. In our system we have currently 61 rules and 331 triggers.
>
>
> On Sat, Mar 7, 2020 at 9:57 AM stan <stanb(at)panix(dot)com <mailto:stanb(at)panix(dot)com>> wrote:
>
> On Sat, Mar 07, 2020 at 09:47:39AM -0500, Justin wrote:
> > Hi Stan
> >
> > Rules actual are able to rewrite the SQL query sent to postgresql.  Most
> > everyone suggestion is avoid rules.
> >
> > Triggers are just like every other databases Triggers firing off code for
> > Insert/Update/Delete/Truncate event
> > https://www.postgresql.org/docs/current/sql-createtrigger.html
> >
>
> So, the RULE can actually rewrite the query, instead of replacing it,
> which is what I m doing in the function, correct?
> --
> "They that would give up essential liberty for temporary safety deserve
> neither liberty nor safety."
>                                                 -- Benjamin Franklin
>

--
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt