Re: Bug #771: rewrite rules on update or insert do not report errors

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: marc(dot)persuy(at)wanadoo(dot)fr, pgsql-bugs(at)postgresql(dot)org
Subject: Re: Bug #771: rewrite rules on update or insert do not report errors
Date: 2002-09-17 14:32:03
Message-ID: 23762.1032273123@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

pgsql-bugs(at)postgresql(dot)org writes:
> If you try to use rules to implement update and insert on views, these
> rules do not report any error neither on insert nor on update action.

I see nothing in here that should raise an error.

> the tiers view shows all datas from user and his/her partners, is
> supposed to allow update of his/her own datas.

You seem to be thinking that the system should somehow intuit that
that's the behavior you want. If you want it to act that way, you need
to code the rules to enforce it. There is no magic to a rule: it does
what you tell it to do.

regards, tom lane

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2002-09-17 19:00:42 Re: Bug #771: rewrite rules on update or insert do not report errors
Previous Message pgsql-bugs 2002-09-17 14:05:05 Bug #771: rewrite rules on update or insert do not report errors