X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 357FCD1B929 for ; Sat, 23 Aug 2003 13:51:28 -0300 (ADT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 57179-09 for ; Sat, 23 Aug 2003 13:51:18 -0300 (ADT) Received: from news.hub.org (unknown [64.117.224.194]) by svr1.postgresql.org (Postfix) with ESMTP id 9B648D1D34C for ; Sat, 23 Aug 2003 13:51:17 -0300 (ADT) Received: from news.hub.org (host-64-117-224-194.altec1.com [64.117.224.194] (may be forged)) by news.hub.org (8.12.9/8.12.9) with ESMTP id h7NGpHek089578 for ; Sat, 23 Aug 2003 16:51:17 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.12.9/8.12.9/Submit) id h7NGdoB0087632 for pgsql-admin@postgresql.org; Sat, 23 Aug 2003 16:39:50 GMT From: "Chris M" X-Newsgroups: comp.databases.postgresql.admin Subject: Re: template1 database... Date: Sun, 24 Aug 2003 00:38:35 +0800 Organization: N/A Lines: 39 Message-ID: References: X-Complaints-To: usenet@news.hub.org X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2800.1158 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 To: pgsql-admin@postgresql.org X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200308/270 X-Sequence-Number: 9991 The link is very good. But another question. In PostgreSQL, a superuser can modify almost everything in the databases. But I don't think that should be the default. Maybe adding an option is better. When a superuser want to change something owned by the system, he or she can turn the option on, then do what he want. After that, the option should be turned back to off. "Devrim GUNDUZ" news:Pine.LNX.4.44.0308202243580.10233-100000@emo.org.tr... > > Hi, > > On Wed, 20 Aug 2003, Thomas LeBlanc wrote: > > > We have accidentally added tables and other objects to this database. > > > > How do we return template1 back to the default setup? > > I think this will help you: > > http://techdocs.postgresql.org/techdocs/pgsqladventuresep1.php > Written by Josh Berkus. > > Regards, > -- > Devrim GUNDUZ > devrim@gunduz.org devrim.gunduz@linux.org.tr > http://www.tdmsoft.com > http://www.gunduz.org > > > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org) >