pgsql: Avoid sometimes printing both tables and their columns in DROPC - Mailing list pgsql-committers

From Tom Lane
Subject pgsql: Avoid sometimes printing both tables and their columns in DROPC
Date
Msg-id E1gkWdv-0002rw-6a@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
Avoid sometimes printing both tables and their columns in DROP CASCADE.

A cascaded drop might find independent reasons to drop both a table
and some column of the table (for instance, a schema drop might include
dropping a data type used in some table in the schema).  Depending on
the order of visitation of pg_depend entries, we might report the
table column and the whole table as separate objects-to-be-dropped,
or we might only report the table.  This is confusing and leads to
unstable regression test output, so fix it to report only the table
regardless of visitation order.

Per gripe from Peter Geoghegan.  This is just cosmetic from a user's
standpoint, and we haven't actually seen regression test problems in
practice (yet), so I'll refrain from back-patching.

Discussion: https://postgr.es/m/15908.1547762076@sss.pgh.pa.us

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/9194c4270b28bb19b43a0156e5a296d1a0a3dd48

Modified Files
--------------
src/backend/catalog/dependency.c | 16 ++++++++++++++--
1 file changed, 14 insertions(+), 2 deletions(-)


pgsql-committers by date:

Previous
From: Peter Eisentraut
Date:
Subject: pgsql: Remove obsolete comment
Next
From: Alvaro Herrera
Date:
Subject: pgsql: Refactor duplicate code into DeconstructFkConstraintRow