Inheritance and views
| От | DaVinci |
|---|---|
| Тема | Inheritance and views |
| Дата | |
| Msg-id | 20010404140713.A8158@fangorn.net обсуждение исходный текст |
| Ответы |
Re: Inheritance and views
|
| Список | 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
В списке pgsql-general по дате отправления: