Re: [GENERAL] Don't cascade drop to view

2008-01-17 Thread Martijn van Oosterhout
On Thu, Jan 17, 2008 at 11:10:25AM -0600, Erik Jones wrote: > If you dropped tables out from under views, how would you expect them > to act if someone were to query them? Inconsistent and unpredictable > are just two words I'd use to describe a system that allowed that. I'd expect it to t

Re: [GENERAL] Don't cascade drop to view

2008-01-17 Thread Erik Jones
On Jan 17, 2008, at 8:27 AM, Sim Zacks wrote: 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, th

Re: [GENERAL] Don't cascade drop to view

2008-01-17 Thread Sim Zacks
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 probl

[GENERAL] Don't cascade drop to view

2008-01-17 Thread Peter Bauer
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 ini