pgsql: Don't recommend "DROP SCHEMA information_schema CASCADE".

From: Noah Misch <noah(at)leadboat(dot)com>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Don't recommend "DROP SCHEMA information_schema CASCADE".
Date: 2017-09-27 05:42:39
Message-ID: E1dx57H-0003Bl-HD@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

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.GE3963697@rfd.leadboat.com

Branch
------
REL9_6_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/b5ee5328bdd086fa7db1845928ef0bc87b495aaf

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 ++++++++++++++++++++++++++++++++++++-------
doc/src/sgml/release-9.6.sgml | 44 ++++++++++++++++++++++++++++++++++++-------
5 files changed, 185 insertions(+), 35 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Alvaro Herrera 2017-09-27 10:05:59 ALTER enums (was Re: [COMMITTERS] pgsql: doc: first draft of Postgres 10 release notes)
Previous Message Peter Eisentraut 2017-09-26 20:43:26 pgsql: Add some more pg_receivewal tests