ERROR: cannot drop table artist because other objects depend on it
DETAIL: constraint album_artist_id_fkey on table album depends on table artist
HINT: Use DROP ... CASCADE to drop the dependent objects too.
The drop is blocked, even if the FK is declared SET NULL or CASCADE.
But what about HINT: Use DROP ... CASCADE to drop the dependent objects too.