| From: | David Ford <david+cert(at)blue-labs(dot)org> |
|---|---|
| To: | Thomas Lockhart <thomas(at)fourpalms(dot)org> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: very concerning, tables hopped from one database to |
| Date: | 2002-04-21 22:54:41 |
| Message-ID: | 3CC34331.8020908@blue-labs.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2002-04-21 23:10:19 | Re: very concerning, tables hopped from one database to |
| Previous Message | Tom Lane | 2002-04-21 22:31:22 | Re: very concerning, tables hopped from one database to another |