Re: very concerning, tables hopped from one database to

Yes, they are in template1.

This then begs the question, why are they not in the hmzbook database?
 All the tables were added via psql -f /tmp/dump.hmzbook which has one
connect line in it.  \connect hmzbook xxxx.

David

Thomas Lockhart wrote:

>...
>
>
>>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
>
>