Inheritance and views

From: DaVinci <bombadil(at)wanadoo(dot)es>
To: Lista PostgreSql <pgsql-general(at)postgresql(dot)org>
Subject: Inheritance and views
Date: 2001-04-04 12:07:13
Message-ID: 20010404140713.A8158@fangorn.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

David

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Neil Conway 2001-04-04 12:23:35 Re: tuple too big error
Previous Message J.H.M. Dassen Ray 2001-04-04 11:26:12 Re: unrecognized language plpgsql