Re: Cascade delete views?

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: Cascade delete views?
Дата
Msg-id Pine.LNX.4.21.0009192230060.362-100000@peter
обсуждение исходный текст
Ответ на Cascade delete views?  (Philip Warner <pjw@rhyme.com.au>)
Список 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 по дате отправления:

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Improved regression test driver
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: -S is missing in postgresql.conf?