Re: Empty database creation???

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Carol Walter <walterc(at)indiana(dot)edu>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Empty database creation???
Date: 2008-03-19 22:02:03
Message-ID: 21502.1205964123@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Carol Walter <walterc(at)indiana(dot)edu> writes:
> ... Why does this come back
> with all the tables intact when I drop it and recreate a database
> with the same name?

Most likely, you accidentally created all that stuff in template1,
and CREATE DATABASE is just copying it from there. Clean out template1.

regards, tom lane

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message smp 2008-03-20 04:37:10 Cannot start PGSQL
Previous Message Joshua D. Drake 2008-03-19 21:59:39 Re: Empty database creation???