Tue May 10 23:17:21 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 ]
On Tue, 2005-05-10 at 17:12, 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? Ummm, that would be the fourth line ken... ugh. Either too much or not enough caffeine...
- 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