Don't recommend "DROP SCHEMA information_schema CASCADE". It drops objects outside information_schema that depend on objects inside information_schema. For example, it will drop a user-defined view if the view query refers to information_schema.
Discussion: https://postgr.es/m/20170831025345.ge3963...@rfd.leadboat.com Branch ------ REL9_5_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/2e7f6b6b2a214f8f5fa8ec448807c3a1a2c8b897 Modified Files -------------- doc/src/sgml/release-9.2.sgml | 44 ++++++++++++++++++++++++++++++++++++------- doc/src/sgml/release-9.3.sgml | 44 ++++++++++++++++++++++++++++++++++++------- doc/src/sgml/release-9.4.sgml | 44 ++++++++++++++++++++++++++++++++++++------- doc/src/sgml/release-9.5.sgml | 44 ++++++++++++++++++++++++++++++++++++------- 4 files changed, 148 insertions(+), 28 deletions(-) -- Sent via pgsql-committers mailing list (pgsql-committers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-committers