Re: [HACKERS] Cascade delete views?

[Peter Eisentraut]

Philip Warner writes:

> Doing the following:
> 
>     create table test (f1 int);
>     create view v_test as select f1+1 as f11 from test;
>     drop table test;
> 
> then selecting from the view results in:
> 
>     ERROR:  Relation 'test' does not exist
> 
> which is fine.

If you peak into the standard, all DROP commands have a trailing
RESTRICT/CASCADE (mandatory, btw.), which will tell what to do. But it's
extremely hard to implement and keep up to date.

-- 
Peter Eisentraut      [EMAIL PROTECTED]       http://yi.org/peter-e/