Re: Something I don't understand with the use of schemas

From: Guillaume LELARGE <guillaume(dot)lelarge(at)gmail(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Something I don't understand with the use of schemas
Date: 2005-12-12 23:43:08
Message-ID: 200512130043.08276.guillaume.lelarge@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Le Mardi 13 Décembre 2005 00:13, Tom Lane a écrit :
> Guillaume LELARGE <guillaume(dot)lelarge(at)gmail(dot)com> writes:
> > I've made more tests on schemas. I'm able to drop information_schema and
> > public schemas but I can't drop pg_catalog and pg_toast. It makes me
> > think that only pg_* are system schemas and that public and
> > information_schema are public schemas. Am I right on this one ?
>
> Yeah, both of the latter are intentionally droppable because nothing in
> the core server depends on them. The C code is explicitly aware of both
> pg_catalog and pg_toast, so those are pinned.
>

Thanks for your answer.

--
Guillaume.
<!-- http://abs.traduc.org/
http://lfs.traduc.org/
http://traduc.postgresqlfr.org/ -->

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2005-12-12 23:44:23 Re: 7.3 failure on platypus
Previous Message Jim C. Nasby 2005-12-12 23:43:04 Re: Something I don't understand with the use of schemas