There was discussion of how template1's "public" schema should behave. I think the only solution is to make template1's public schema writable only by the super-user. This way, we can allow utility commands to connect to template1, but they can't change anything or add their own tables.
As part of createdb, the new database will have to have it's public schema changed to world-writable. -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026 ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]