dropping template1

From: "Thomas T(dot) Thai" <tom(at)minnesota(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: dropping template1
Date: 2003-01-09 07:14:47
Message-ID: 1904.63.226.186.156.1042096487.squirrel@mail.minnesota.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Shridhar Daithankar 2003-01-09 07:17:57 Re: dropping template1
Previous Message Jon Thorson 2003-01-09 07:10:08 Re: Can't copy empty value to datatype 'timestamp'