cleaning out template1, and what is template0?

From: Louis-David Mitterrand <cunctator(at)apartia(dot)ch>
To: pgsql-general(at)postgresql(dot)org
Subject: cleaning out template1, and what is template0?
Date: 2001-02-15 16:02:15
Message-ID: 20010215170215.A4347@apartia.ch
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

It sometimes happens that template1 gets accidentally littered with
tables and sequences intended for other databases (forget to \connect,
wrong arg to psql, etc.).

Is it safe to DROP/CREATE template1 for a radical cleanout or should I
merely remove cruft by the item?

In Pg-7.1 there is a new template0 db. What is it used for?

Thanks in advance,

--
THESEE: Quel coup me l'a ravi ? Quelle foudre soudaine ?
THERAMENE: A peine nous sortions des portes de Trzne,
Il tait sur son char. Ses gardes affligs
Imitaient son silence, autour de lui rangs ;
(Phdre, J-B Racine, acte 5, scne 6)

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2001-02-15 16:02:40 Re: regular expression substittion function?
Previous Message Bruce Momjian 2001-02-15 16:01:18 Re: regular expression substittion function?