Ron Snyder wrote: > > As part of createdb, the new database will have to have it's public > > schema changed to world-writable. > > I have to admit that much of the schema related discussion has been over my > head, but I think what I understand you to be saying here is that the > default would be to allow anybody to create tables in any database that they > connect to, in the same way that they currently can (with pg <= 7.2.1). > > (If that's not the case, you can ignore the rest of the message.)
The issue I was raising is the creation of tables in the default 'public' schema, which is the one used by users who don't have a schema matching their name. I was saying that template1 should prevent creation of tables by anyone but the superuser. As far as temp tables, I think we should enable that for all non-template1 databases. (In fact, what happens if you create a database while a temp table exists in template1. Seems it would not be cleaned up in the new database.) -- 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 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
