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" <[EMAIL PROTECTED]> news:[EMAIL PROTECTED] > > 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 > [EMAIL PROTECTED] [EMAIL PROTECTED] > 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 [EMAIL PROTECTED]) > ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
