Tue May 10 23:21:00 PDT 2005
- Previous message: [Slony1-general] a question about EXECUTE SCRIPT
- Next message: [Slony1-general] a question about EXECUTE SCRIPT
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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...
- Previous message: [Slony1-general] a question about EXECUTE SCRIPT
- Next message: [Slony1-general] a question about EXECUTE SCRIPT
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list