Andrew Sullivan ajs at crankycanuck.ca
Tue Dec 11 11:38:21 PST 2007
On Tue, Dec 11, 2007 at 08:28:55PM +0100, cichy wrote:
> are older than a week, but in such way that they are not deleted from the
> second DB. Is it possible with slony? Maybe records with certain values in
> some columns can be ommited from deletion in slave DB?

You can STORE TRIGGER on the second system, that saves those records
somewhere else.  The obvious way to do this is to use a trigger on the
replica that INSTEAD copies the records into a _different_, but that doesn't
fire on DELETE.

A



More information about the Slony1-general mailing list