Re: template1 database...

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(at)gunduz(dot)org>
news:Pine(dot)LNX(dot)4(dot)44(dot)0308202243580(dot)10233-100000(at)emo(dot)org(dot)tr(dot)(dot)(dot)
>
> 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(at)gunduz(dot)org devrim(dot)gunduz(at)linux(dot)org(dot)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(at)postgresql(dot)org)
>