From: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
---|---|
To: | tom <tom(at)outervention(dot)net> |
Cc: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Inheritance clarification please |
Date: | 2001-05-21 15:45:03 |
Message-ID: | Pine.LNX.4.30.0105211743490.757-100000@peter.localdomain |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
tom writes:
> Is the data duplicated or just referenced in the parent table? If it's
> duplicated then the database size and bloat are an issue for me.
Just in the parent table.
> Another question I have is that say I have a parent table users and a child
> table hobbies...one of my users exists only in the users table but now I
> want to add his hobbies...is it possible to change him over to the hobbies
> table without deleting him in the user table, then inserting him into the
> hobbies table from scratch?
No. "Class promotion" is not a common operation in object oriented
systems.
--
Peter Eisentraut peter_e(at)gmx(dot)net http://funkturm.homeip.net/~peter
From | Date | Subject | |
---|---|---|---|
Next Message | Patrick Welche | 2001-05-21 15:45:49 | Re: psql shell problem |
Previous Message | Peter Eisentraut | 2001-05-21 15:28:22 | Re: psql shell problem |