Postgres Pro
Downloads
Home   >   mailing lists

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

From Thomas Lockhart
Subject Re: ALTER TABLE has not effect on children tables?
Date
Msg-id 398199E0.8A99FF4B@alumni.caltech.edu
Whole thread Raw
In response to ALTER TABLE has not effect on children tables?  (Louis-David Mitterrand <cunctator@apartia.ch>)
List pgsql-general
Tree view 
> 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

pgsql-general by date:

Previous
From: Ian Turner
Date:
Subject: Inheritance
Next
From: Ernie
Date:
Subject: Re: performance help