[Top][All Lists]

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

Re: [Gnumed-devel] postgres inheritance

From: Karsten Hilbert
Subject: Re: [Gnumed-devel] postgres inheritance
Date: Sat, 4 Sep 2004 11:13:26 +0200
User-agent: Mutt/

The PG inheritance is fairly limited. It is only safe to use
(re data rows being where they are supposed to be) if one
never ever inserts/updates/deletes into parent tables. Only
selects are fine. To make this more manageable it is wise to
not nest deeper than *one* parent-child level.

Changing data in the parent table does NOT reflect that change
in child tables. No row in child tables is touched then.

So I operated from the firm principle to use inheritance
exclusively for providing common fields to a range of child

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]