[Top][All Lists]

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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

From: Karsten Hilbert
Subject: Re: Re: [Gnumed-devel] use of PG inheritance in GNUmed
Date: Sat, 13 Mar 2004 17:36:21 +0100
User-agent: Mutt/

> > 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.

GPG key ID E4071346 @
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346

reply via email to

[Prev in Thread] Current Thread [Next in Thread]