Thread: ALTER TABLE has not effect on children tables?

ALTER TABLE has not effect on children tables?

From
Louis-David Mitterrand
Date:
When adding a column to a mother table, children tables don't inherit
that new column. I have to add it to each sub-table manually. Is it
normal?

Unrelated problem: after a dropdb/createdb cylce my old tables and
sequences resurect in the un-initialized database. Even after removing
the tables and sequences one by one _before_ dropdb they keep coming
back like zombies when running createdb. What's going on?

Thanks in advance for your help,

--
Louis-David Mitterrand - ldm@apartia.org - http://www.apartia.org

Murphy's Guide to Science:
   If it's green or squirms, it's biology.
   If it stinks, it's chemistry.
   If it doesn't work, it's physics.

Re: ALTER TABLE has not effect on children tables?

From
Thomas Lockhart
Date:
> Unrelated problem: after a dropdb/createdb cylce my old tables and
> sequences resurect in the un-initialized database. Even after removing
> the tables and sequences one by one _before_ dropdb they keep coming
> back like zombies when running createdb. What's going on?

You added these tables to the "template1" database. Remove them from
there, or do an initdb to *really* clean up.

                     - Thomas