Re: Don't cascade drop to view

Unfortuantely, there is no way around it.
Without cascade it won't let you delete the schema or table.
Functions will not be dropped.

Sim

Peter Bauer wrote:
> 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
>