| From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
|---|---|
| To: | Przemysław Sztoch <przemyslaw(at)sztoch(dot)pl> |
| Cc: | PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: DROP VIEW name WITHOUT TYPE |
| Date: | 2024-11-08 14:54:07 |
| Message-ID: | CAKFQuwapBvoG-yP6XboKDLX65aGvwvRKaRufQyferuDACM_snA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Fri, Nov 8, 2024 at 7:51 AM Przemysław Sztoch <przemyslaw(at)sztoch(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ashutosh Bapat | 2024-11-08 14:57:30 | Re: logical replication: restart_lsn can go backwards (and more), seems broken since 9.4 |
| Previous Message | Tomas Vondra | 2024-11-08 14:53:36 | Re: WIP: parallel GiST index builds |