Christopher, Thanks for the correction. I'm a newbie working with slony and all of your remarks are quite welcome.
Unfortunally, I can't really grasp Andrew's scenario or needs. Maybe someone else on this list could be more helpful than me. Regards, Manuel. On 9/13/06, Christopher Browne <[EMAIL PROTECTED]> wrote: > "Manuel Vázquez Acosta" <[EMAIL PROTECTED]> writes: > > As far as I know, Slony-I will not replicate schema changes like > > create table. I'm not sure if the same applies to GRANT and REVOKE. > > That is not particularly accurate. > > Slony-I will not *automatically* propagate changes to schemas; in > order to coordinate that sort of change, you must submit schema > changes via the slonik "EXECUTE SCRIPT" facility. EXECUTE SCRIPT most > certainly *does* replicate schema changes; that's what it is for. > > You could propagate changes like GRANT and REVOKE via "EXECUTE > SCRIPT." > -- > (format nil "[EMAIL PROTECTED]" "cbbrowne" "ca.afilias.info") > <http://dba2.int.libertyrms.com/> > Christopher Browne > (416) 673-4124 (land) > _______________________________________________ Slony1-general mailing list [email protected] http://gborg.postgresql.org/mailman/listinfo/slony1-general
