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