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.