Postgres Pro
Downloads
Home   >   mailing lists

dropping template1 - Mailing list pgsql-general

From Thomas T. Thai
Subject dropping template1
Date
Msg-id 1904.63.226.186.156.1042096487.squirrel@mail.minnesota.com
Whole thread Raw
Responses Re: dropping template1  ("Shridhar Daithankar" <shridhar_daithankar@persistent.co.in>)
List pgsql-general
Tree view 
I'm using 7.3 and accidently created unnecessary functions and such in
template1. Originally it had nothing added beyond the initial install
(initdb). I would like to return it to the clean state.

drop database template1;
ERROR:  DROP DATABASE: database is marked as a template

Is there another way?

pgsql-general by date:

Previous
From: Jon Thorson
Date:
Subject: Re: Can't copy empty value to datatype 'timestamp'
Next
From: "Shridhar Daithankar"
Date:
Subject: Re: dropping template1