But this way i will touch both the schema AND data
And what i want is to change the schema ONLY.
Thanks
On Sun, 18 Jul 2004, Stephan Szabo wrote:
> On Tue, 13 Jul 2004, evgeny tsurkin wrote:
>
> > Hi All!
> > That probably was already asked thousand times
> > but i did not find an exact answer:
> > I want to have two tables the second one will have
> > all the columns from the first + some extra .The data
> > should be complittly separate .I was trying to use
> > inheritance and setted the SQL_INHERITANCE = false
> > to separate the data ,but when trying to add a column
> > to the father i have got an error:
> > ERROR: Attribute must be added to child tables too
> > what can i do ?
>
> Either don't use SQL_INHERITANCE=false, or specify that you want
> to act upon the entire tree using the older syntax which I think
> would look like ALTER TABLE first* add column ...
> (note the *)
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings
>
--
-------------------------------------------
Evgeny.