[Top][All Lists]

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

[Gnumed-devel] postgres inheritance

From: J Busser
Subject: [Gnumed-devel] postgres inheritance
Date: Fri, 3 Sep 2004 11:45:57 -0700

I am trying to better understand postgres inheritance

in the example given at

Suppose you input "Honolulu City" and you wish it recorded that it is a capital (of Hawaii).

Does appending a row into"cities" cause a new row to automatically be created in "capitals"?
Does one then update what was a default "state" value to be "Hawaii"?

Or is a row not created until someone inputs "Hawaii"?

Are users prevented from accessing the child table "capitals" directly? Otherwise if they appended a row and input a value for "state" (say "Michigan") the resulting row risks having no connection to any row in "cities"; would an empty row be created in "cities"?

reply via email to

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