ALTER TABLE has not effect on children tables? - Mailing list pgsql-general

From Louis-David Mitterrand
Subject ALTER TABLE has not effect on children tables?
Date
Msg-id 20000728151131.A1192@styx
Whole thread Raw
List pgsql-general
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.

pgsql-general by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: Re: pg_dump problem
Next
From: Jeffery Collins
Date:
Subject: Re: Connection problem under extreme load.