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 <cbbrowne at ca.afilias.info> wrote:
> "Manuel V?zquez Acosta" <mva.led at gmail.com> 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 "~S@~S" "cbbrowne" "ca.afilias.info")
> <http://dba2.int.libertyrms.com/>
> Christopher Browne
> (416) 673-4124 (land)
>