Re: Cascade delete views? - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: Cascade delete views?
Date
Msg-id Pine.LNX.4.21.0009192230060.362-100000@peter
Whole thread Raw
In response to Cascade delete views?  (Philip Warner <pjw@rhyme.com.au>)
List pgsql-hackers
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      peter_e@gmx.net       http://yi.org/peter-e/



pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Solution for RI permission problem
Next
From: Peter Eisentraut
Date:
Subject: Re: -S is missing in postgresql.conf?