| From: | Oliver Elphick <olly(at)lfix(dot)co(dot)uk> |
|---|---|
| To: | Gan Uesli Starling <gan(at)starling(dot)us> |
| Cc: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: Dropping sub-tables |
| Date: | 2006-02-06 09:43:26 |
| Message-ID: | 1139219006.31760.21.camel@linda.lfix.co.uk |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
On Wed, 2006-02-01 at 17:59 -0500, Gan Uesli Starling wrote:
> Say I have a table for equipment having columns for ordinary
> equipment. It also has sub-tables for things like sensors with
> extra columns for specialty info.
>
> I'd like to revert to having only the main table without any
> sub-tables, but keep the rows from the sub-tables which are
> common to the parent table.
>
> If I drop the sub-tables, do I loose all if their rows, or
> only the columns not shared with the parent table?
I assume you are talking about inheritance, so the answer is yes, you
will lose all their rows.
--
Oliver Elphick olly(at)lfix(dot)co(dot)uk
Isle of Wight http://www.lfix.co.uk/oliver
GPG: 1024D/A54310EA 92C8 39E7 280E 3631 3F0E 1EC0 5664 7A2F A543 10EA
========================================
Do you want to know God? http://www.lfix.co.uk/knowing_god.html
| From | Date | Subject | |
|---|---|---|---|
| Next Message | operationsengineer1 | 2006-02-06 17:51:02 | Re: maximum for database users? |
| Previous Message | Paul Smith | 2006-02-05 02:15:02 | Re: phpPgAdmin login problem |