| 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: | Whole Thread | Raw Message | 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
| 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 |