Alan Hodgson ahodgson
Fri Jan 7 17:01:45 PST 2005
On Fri, Jan 07, 2005 at 05:41:35PM +0100, Christian Michel @ amplix wrote:
> The SQL-Statements are called after an unsubscribe node();
> After the SQL-statements a subscribe node () is called.
> 
> The schema-update works fine, but slony-Log offers an error, that
> COPY fails, because the table-structure didn't fit the content of COPY
> anymore.
>

If you unsubscribed the slave first, then the EXECUTE SCRIPT didn't
run against it, so your schema is now different.  Which is why
the copy failed.  EXECUTE SCRIPT is meant to run against all
current subscribers.

-- 
"If a nation expects to be ignorant and free, in a state of civilization,
it expects what never was and never will be." -- Thomas Jefferson



More information about the Slony1-general mailing list