Postgres Pro
Downloads
Home   >   mailing lists

Re: DROP TABLE CASCADE doesn't drop dependencies - Mailing list pgsql-bugs

From Tom Lane
Subject Re: DROP TABLE CASCADE doesn't drop dependencies
Date
Msg-id 25327.1549237340@sss.pgh.pa.us
Whole thread Raw
In response to DROP TABLE CASCADE doesn't drop dependencies  (Robins Tharakan <tharakan@gmail.com>)
Responses Re: DROP TABLE CASCADE doesn't drop dependencies  (Robins Tharakan <tharakan@gmail.com>)
List pgsql-bugs
Tree view 
Robins Tharakan <tharakan@gmail.com> writes:
> Is it expected for DROP TABLE CASCADE to find a related table but not drop
> it?
> The case in point, is when the base table is used as a column type.
> This can at least be reproduced in v9.6 and v10, where it silently drops
> the column!

Dropping the column is exactly what is supposed to happen: the scope
of the dependency is defined to be just the column of that type, not
the table containing it.

Not sure if this is documented anyplace in the SGML docs, but I'm
pretty sure we have regression test cases for it.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Robins Tharakan
Date:
Subject: DROP TABLE CASCADE doesn't drop dependencies
Next
From: Robins Tharakan
Date:
Subject: Re: DROP TABLE CASCADE doesn't drop dependencies