Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group