Glyn Astill wrote:
> Hi chaps,
>
> I've put a couple of extra views in my slony schemas, and I just wondered if there's any chance they could interfere with any of slonys functions or processes as they go about their business?
>
> Permissions are not granted to the slony user, but that shouldn't mater as its a superuser.
>
> Should I move them somewhere else to be safe?
>   
I wouldn't see any problem with that in general.

The only times that Slony messes around with the schema itself are

a) When creating it (right at the start).  You don't have a Slony-I 
schema yet at that point to have added anything into, so there's very 
little risk there :-).

b) When upgrading from one version to another, which is special enough 
in other ways :-).

 From a "general hygiene" perspective I'd not want to have views that 
aren't related to replication in that schema, but if you have some view 
you use for monitoring replication, that would be a good place to stow it.

-- 
(format nil "~S@~S" "cbbrowne" "ca.afilias.info")
<http://dba2.int.libertyrms.com/>
Christopher Browne
(416) 673-4124 (land)