From: Chris M <chris@none.none>
To: pgsql-admin@postgresql.org
Subject: Re: template1 database...
Date: Sun, 24 Aug 2003 00:38:35 +0800
Message-ID: <bi85cj$2lid$1@news.hub.org> (raw)
References: <Law9-F58nSr1ggpkHC7000001f2@hotmail.com>
<Pine.LNX.4.44.0308202243580.10233-100000@emo.org.tr>
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" <devrim@gunduz.org>
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)
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: chris@none.none
Subject: Re: template1 database...
In-Reply-To: <bi85cj$2lid$1@news.hub.org>
References: <Law9-F58nSr1ggpkHC7000001f2@hotmail.com> <Pine.LNX.4.44.0308202243580.10233-100000@emo.org.tr> <bi85cj$2lid$1@news.hub.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox