Don't cascade drop to view

Поиск
Список
Период
Сортировка
От Peter Bauer
Тема Don't cascade drop to view
Дата
Msg-id 200801171508.33184.peter.bauer@apus.co.at
обсуждение исходный текст
Ответы Re: Don't cascade drop to view  (Sim Zacks <sim@compulab.co.il>)
Список pgsql-general
Hi all,

i made some views for the slony1 configuration tables in the public schema
which refer to tables in the _slony1 schema. My problem now is that if the
_slony1 schema is dropped with cascade or slony is uninstalled, these views
are also dropped and i have to recreate them if slony is initialized again.
Is there a possibility to let the views live there even if the refered schema
or tables are dropped? Would a plpgsql Function also be dropped?

thx,
Peter

--
Peter Bauer
APUS Software G.m.b.H.
A-8074 Raaba, Bahnhofstrasse 1/1
Email: peter.bauer@apus.co.at
Tel: +43 316 401629 24
Fax: +43 316 401629 9

В списке pgsql-general по дате отправления:

Предыдущее
От: Sebastián Baioni
Дата:
Сообщение: Re: Can't make backup (again)
Следующее
От: Sim Zacks
Дата:
Сообщение: Re: Don't cascade drop to view