Re: very concerning, tables hopped from one database to

From: Thomas Lockhart <thomas(at)fourpalms(dot)org>
To: David Ford <david+cert(at)blue-labs(dot)org>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: very concerning, tables hopped from one database to
Date: 2002-04-21 22:28:09
Message-ID: 3CC33CF9.1AF54A15@fourpalms.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

...
> What the heck just happened and short of dumping these tables out and
> importing them back into the other database...

Most likely, you accidentally added the tables to template1, which then
propagates to any new databases added after that.

Clean up template1, then clean up your existing databases, and you
should be back to normal for any new ones. dump/reload is not required,
except to get tables into databases which need them.

- Thomas

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2002-04-21 22:31:22 Re: very concerning, tables hopped from one database to another
Previous Message David Ford 2002-04-21 22:27:15 (very anxious, tables hopping databases ....)