Guillaume LELARGE <[EMAIL PROTECTED]> 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.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings