Postgres Pro
Downloads
Home   >   mailing lists

Re: DROP VIEW name WITHOUT TYPE - Mailing list pgsql-hackers

From David G. Johnston
Subject Re: DROP VIEW name WITHOUT TYPE
Date
Msg-id CAKFQuwapBvoG-yP6XboKDLX65aGvwvRKaRufQyferuDACM_snA@mail.gmail.com
Whole thread Raw
In response to DROP VIEW name WITHOUT TYPE  (Przemysław Sztoch <przemyslaw@sztoch.pl>)
List pgsql-hackers
Tree view
On Fri, Nov 8, 2024 at 7:51 AM Przemysław Sztoch <przemyslaw@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.

pgsql-hackers by date:

Previous
From: Tomas Vondra
Date:
Subject: Re: WIP: parallel GiST index builds
Next
From: Ashutosh Bapat
Date:
Subject: Re: logical replication: restart_lsn can go backwards (and more), seems broken since 9.4