Re: ALTER TABLE has not effect on children tables?

From: Thomas Lockhart <lockhart(at)alumni(dot)caltech(dot)edu>
To: ldm(at)apartia(dot)ch
Cc: Postgres Users <pgsql-general(at)postgresql(dot)org>
Subject: Re: ALTER TABLE has not effect on children tables?
Date: 2000-07-28 14:34:08
Message-ID: 398199E0.8A99FF4B@alumni.caltech.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Thomas Lockhart 2000-07-28 14:41:11 Re: Re: [GENERAL] Some questions on user defined types and functions.
Previous Message Ian Turner 2000-07-28 14:12:19 Inheritance