Skip site navigation (1) Skip section navigation (2)

inheritance ...

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 (view raw or flat)
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 ?

pgsql-novice by date

Next:From: mikeoDate: 2000-05-16 17:02:27
Subject: remove line type?
Previous:From: Jørgen RamskovDate: 2000-05-16 07:51:35
Subject: Binaries for NT?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group