| From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | PostgreSQL-development <pgsql-hackers(at)postgreSQL(dot)org> |
| Subject: | Schemas and template1 |
| Date: | 2002-06-11 22:24:14 |
| Message-ID: | 200206112224.g5BMOFb23450@candle.pha.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-interfaces |
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
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2002-06-11 22:39:39 | Re: PATCH SSL_pending() checks in libpq/fe-misc.c |
| Previous Message | Thomas Lockhart | 2002-06-11 21:53:14 | Re: New string functions; initdb required |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2002-06-12 02:57:57 | Re: Schemas and template1 |
| Previous Message | Bruce Momjian | 2002-06-11 20:51:57 | Re: Where is PLbash ?? |