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
>