On Sat, Jun 07, 2008 at 02:05:27PM +0200, Marcin Kasperski wrote: > So I'd like to remove old data from "events" in ProductionDatabase, > but would like to keep them in ReportDatabase. > > Is it possible to convince Slony to ignore such a DELETE
No, but you could put a trigger in the report database that actually puts the records in a _different_ table, and use views to see things (so you don't really need to change your application). Ideally, you'll want to partition by year or something anyway, because eventually you're probably going to want to drop records off the table (like, records 7 years old, maybe?). A _______________________________________________ Slony1-general mailing list [email protected] http://lists.slony.info/mailman/listinfo/slony1-general
