From: | Loïc TREGOUËT <loic(at)cri74(dot)org> |
---|---|
To: | pgsql-general(at)postgresql(dot)org, pgsql-admin(at)postgresql(dot)org, pgsql-novice(at)postgresql(dot)org |
Subject: | inheritance ... |
Date: | 2000-05-16 12:26:35 |
Message-ID: | 39213E7B.E76F7EDE@cri74.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Hie alll ,
I've the folowing problem :
I've create a table cities :
create table cities (name varchar(20) , population int4) ;
I've also create a table capitals with inheritance :
create table capitals (country varchar(20) ) inherits (cities) ;
But when i want to add a column to cities , the column is not added to
capitals : this is not a object approach ! Isn't it ? How can i do ?
Thanks for the response
Loic
P.S : one time , i've add a column to the table cities and i had the
result ADD but i couldn't see the column added ! Have you ever heard
about this ?
From | Date | Subject | |
---|---|---|---|
Next Message | mikeo | 2000-05-16 17:02:27 | remove line type? |
Previous Message | Jørgen Ramskov | 2000-05-16 07:51:35 | Binaries for NT? |