Re: Re: [Gnumed-devel] use of PG inheritance in GNUmed

[Karsten Hilbert]

> > Back-inheritance of rows to the ancestor is useful: when we implement
> > a "notes browser" we want to search all 
> > the clinical tables for anything that happened during a particular
> > time, with a        common ancestor we can do this in one query.
> > (as opposed to ~10, more as we add features) Problem is, this query
> > can't access the descendant columns that contain all the 
Yes it can. It needs to match parent.tableoid against
sys.relid of the child table.

> OK, thanks, although it still seems arse-about that PG works this way.
PG is pending to add more complete inheritance but no one has
picked up that tab as of yet.

Karsten
-- 
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346