Andrew Sullivan ajs
Tue Sep 7 18:02:51 PDT 2004
On Tue, Sep 07, 2004 at 05:42:23PM +0100, Richard Frith-Macdonald wrote:
> The documentation focusses on using slonik rather than calling the 
> stored procedures directly ...
> does this imply that use of the stored procedures is discouraged or 
> that the api is unstable?

The former.  Slony is designed on the assumption that schema changes
to the database are a rare occurrence.  I have heard Jan argue that
systems that change their own schemas are guilty of being
self-modifying code.  Whether that charge is just, the notion is
still that the schema needs to be pretty stable.

If the schema is not stable, I'd suggest that the data in those
tables can't be that valuable, so replication may not be what you
need of the data.

If you disagree with that view, I understand that Command Prompt's
Mammoth Replicator may be able to help.

A

-- 
Andrew Sullivan  | ajs at crankycanuck.ca
The fact that technology doesn't work is no bar to success in the marketplace.
		--Philip Greenspun


More information about the Slony1-general mailing list