Inheritance and views

On Wed, Apr 04, 2001 at 02:07:13PM +0200, DaVinci wrote:

Hello.

I'd like to implement for my DB a mechanism of backup based in inherited
tables. I explain it in detail:

Idea is simple: table B inherits from table A. Anualy, data from table A is
dumped in B. So, from frontend it is posible to access current data (from
A) or all data (A + B).

Problem is that I'd like also implement a view for A and B, but I don't
know what is best way. View(s) must have rules for insert and update. Can
view from A access data from B without problem (eliminating "ONLY" from
select)?. Is there another better form of implementing this backup
mechanism?. I'd not want to reinvent the wheel ;)

Thanks for your ideas.

Maybe...

SELECT * FROM A* ;

Notice the asterisk on the superclass table name.

--
Eric G. Miller <egm2@jps.net>