
> But the RULE system is not really suited to this. I havn't written it
all
> out but by my calculations the number of rules required is about
(N^2+N)/2
> where N is the number of partitions. That's one UPDATE rule for each
pair of
> tables plus a set of INSERT rules (DELETE requires nothing special).
And
> each of those rules will be used every single time that table is
queried
> (both inserts and updates). That's not terribly efficient.
> Mind you, maybe there's a better way of doing it. I havn't totally
gotten my
> head around rules. Maybe it indicates that improvements could be made
to the
> rule system.

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.

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).

Andreas

Mon, 19 May 2003 13:59:52 +0200
"Zeugswetter Andreas SB SD" <ZeugswetterA@spardat.at>
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
Mon, 19 May 2003 23:17:48 +1000
Martijn van Oosterhout <kleptog@svana.org>
Re: Feature suggestions (long)