Search Postgresql Archives

Don't cascade drop to view

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxxx
Tel: +43 316 401629 24
Fax: +43 316 401629 9

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux