Re: ERROR action extension for rules?

From: Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: PostgreSQL Developers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: ERROR action extension for rules?
Date: 2004-04-21 07:21:03
Message-ID: Pine.LNX.4.58.0404210908360.6454@sablons.cri.ensmp.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


> > CREATE RULE PasTouche AS ON UPDATE TO foo
> > WHERE old.locked=TRUE
> > DO INSTEAD ERROR;
>
> This would be sensible if rules were actually reasonable substitutes for
> triggers, but they are not.
>
> If you check the archives you will find many many cases where people
> tried to do this sort of thing, and got burned by the fundamental
> semantic differences ...

Ok, I'll look into that. Thanks for the pointer.

--
Fabien Coelho - coelho(at)cri(dot)ensmp(dot)fr

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Matthew T. O'Connor 2004-04-21 11:59:45 Re: pg_autovacuum crashes when query fails for temp tables
Previous Message Joe Conway 2004-04-21 05:23:05 Re: Duplicate variable declared?