ALTER TABLE has not effect on children tables?

From: Louis-David Mitterrand <cunctator(at)apartia(dot)ch>
To: Postgres Users <pgsql-general(at)postgresql(dot)org>
Subject: ALTER TABLE has not effect on children tables?
Date: 2000-07-28 13:11:31
Message-ID: 20000728151131.A1192@styx
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)apartia(dot)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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ian Turner 2000-07-28 14:12:19 Inheritance
Previous Message Andrew Sullivan 2000-07-28 13:10:51 Re: Re: pg_dump problem