Re: Feature suggestions (long)

On Mon, May 19, 2003 at 01:59:52PM +0200, Zeugswetter Andreas SB SD wrote:
> What you need is one view that is a union all select selecting all your
> partial tables, all applications only accesses this one view.  You need 1
> insert 2 update 1 delete rule for each table plus 3 remainder rules (=4*N
> + 3 rules) (the select rule is already done by create view), plus one
> check constraint for each partial table.

WOW! You *are* good. Care to reveal the trick? I can see the insert and
delete rules but what are you doing for the updates?

> You can restrict access to the partial tables with normal grant/revoke's.
> The appls only need grants on the view (which is updateable with above
> rules).

Good point.

--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> "the West won the world not by the superiority of its ideas or values or
> religion but rather by its superiority in applying organized violence.
> Westerners often forget this fact, non-Westerners never do."
>   - Samuel P. Huntington