Christopher Browne cbbrowne
Tue May 10 23:21:00 PDT 2005
Scott Marlowe wrote:

>UPDATE UPDATE UPDATE UPDATE
>
>The third line here is what's killing it.  The update.
>
>ALTER TABLE BUSINESSREQUESTSUMMARY ADD AVERAGERESPONSETIME_
>NUMERIC(8,0);
> ALTER TABLE BUSINESSREQUESTSUMMARY ADD LOWESTRESPONSETIME_
>NUMERIC(8,0);
> ALTER TABLE BUSINESSREQUESTSUMMARY ADD HIGHESTRESPONSETIME_
>NUMERIC(8,0);
> UPDATE BUSINESSREQUESTSUMMARY SET
>AVERAGERESPONSETIME_=AVERAGERESPONSETIME,
>LOWESTRESPONSETIME_=LOWESTRESPONSETIME,
>HIGHESTRESPONSETIME_=HIGHESTRESPONSETIME;
>
>Does that help?
>  
>
Not really.  The problem is presumably specifically related to your
schema, and likely to some mismatch between what is on the origin versus
the subscribers.

There's probably something breaking about

 UPDATE BUSINESSREQUESTSUMMARY SET
AVERAGERESPONSETIME_=AVERAGERESPONSETIME,
LOWESTRESPONSETIME_=LOWESTRESPONSETIME,
HIGHESTRESPONSETIME_=HIGHESTRESPONSETIME;

but that'll be specific to your environment...




More information about the Slony1-general mailing list