Horton
Menu

dropping template1

Thomas T. Thai <tom@minnesota.com>

View thread
From: "Thomas T. Thai" <tom@minnesota.com>
To: <pgsql-general@postgresql.org>
Date: 2003-01-09T07:14:47Z
Lists: pgsql-general 
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?