Don't cascade drop to view - Mailing list pgsql-general

From Peter Bauer
Subject Don't cascade drop to view
Date
Msg-id 200801171508.33184.peter.bauer@apus.co.at
Whole thread Raw
Responses Re: Don't cascade drop to view
List 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 by date:

Previous
From: Sebastián Baioni
Date:
Subject: Re: Can't make backup (again)
Next
From: Sim Zacks
Date:
Subject: Re: Don't cascade drop to view