Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group