On Fri, Nov 8, 2024 at 7:51 AM Przemysław Sztoch <przemys...@sztoch.pl>
wrote:

> Is it possible to extend DROP VIEW command:
>
> DROP VIEW [ IF EXISTS ] *name* [, ...] [ CASCADE | RESTRICT | WITHOUT TYPE]
>
> I want to allow to DROP VIEW if any objects depend on it.
>
> Am I right, If we leave (or convert) TYPE linked to VIEW, then DROP will be 
> possible?
>
>
No...you can't write "select * from type_name" and that is going to be the
most common kind of dependency you have to deal with.

David J.

Reply via email to