Don't cascade drop to view

From: Peter Bauer <peter(dot)bauer(at)apus(dot)co(dot)at>
To: pgsql-general(at)postgresql(dot)org
Subject: Don't cascade drop to view
Date: 2008-01-17 15:08:33
Message-ID: 200801171508.33184.peter.bauer@apus.co.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(dot)bauer(at)apus(dot)co(dot)at
Tel: +43 316 401629 24
Fax: +43 316 401629 9

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2008-01-17 15:15:38 Re: Help with pre-loaded arbitrary key sequences
Previous Message James B. Byrne 2008-01-17 15:05:24 Re: Help with pre-loaded arbitrary key sequences