| From: | "John Sidney-Woollett" <johnsw(at)wardbrook(dot)com> |
|---|---|
| To: | "Kris Jurka" <books(at)ejurka(dot)com> |
| Cc: | "Mike Nolan" <nolan(at)gw(dot)tssi(dot)com>, "Matthew Nuzum" <cobalt(at)bearfruit(dot)org>, "'P(dot)J(dot) \"Josh\" Rovero'" <rovero(at)sonalysts(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: measuring disk usage of records |
| Date: | 2004-01-02 09:36:47 |
| Message-ID: | 3631.192.168.0.64.1073036207.squirrel@mercury.wardbrook.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
If you have a language installed (like pl/pgsql), then dropping the public
schema also drops the language. Ouch.
Maybe there is a solution to that one though...
John Sidney-Woollett
Kris Jurka said:
>
>
> On Wed, 31 Dec 2003, Mike Nolan wrote:
>
>> That raises an interesting question. Can pg be configured so
>> that user tables MUST be in user schemas, i.e., nobody can put tables
>> in the PUBLIC schema?
>
> Sure, you can simply drop the public schema, or "revoke all on schema
> public from public";
>
> Kris Jurka
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Chris Travers | 2004-01-02 11:38:25 | Help with PostgreSQL porting project |
| Previous Message | Lynn.Tilby | 2004-01-02 05:10:06 | Cursor Not Found |