Geoffrey lists at serioustechnology.com
Thu Apr 23 07:13:41 PDT 2009
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


More information about the Slony1-general mailing list