Thu Apr 23 07:13:41 PDT 2009
- Previous message: [Slony1-general] will truncating a table on the master be properly handled by slony on the slave?
- Next message: [Slony1-general] will truncating a table on the master be properly handled by slony on the slave?
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Andrew Sullivan wrote: > On Thu, Apr 23, 2009 at 09:32:57AM -0400, Geoffrey wrote: >> Subject says it. If I truncate a table on my master, will that be >> properly handled on the slave? > > The manual says > > TRUNCATE will not run any ON DELETE triggers that might exist for > the tables. > > So no, if you mean "will the truncate happen on the replica too?" Yeah, that's what I mean, so this is likely why these two tables are out of sync. They were truncated earlier this year. So, the solution to this is, I assume 'execute script?' Also, what is the best way to get these tables back in sync without trashing slony and starting over? Can we drop the tables from replication and re-add them? -- Until later, Geoffrey Those who would give up essential Liberty, to purchase a little temporary Safety, deserve neither Liberty nor Safety. - Benjamin Franklin
- Previous message: [Slony1-general] will truncating a table on the master be properly handled by slony on the slave?
- Next message: [Slony1-general] will truncating a table on the master be properly handled by slony on the slave?
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list