[Babase] AMOK Questions
Karl O. Pinc
kop at meme.com
Mon Aug 4 10:21:35 EDT 2008
On 08/04/2008 08:45:57 AM, Susan Alberts wrote:
> Thanks for the input Jeanne. See below.
Am I supposed to be there for the conference call?
>>
>> 2. I favor a single line, probably with the AMO name, the name
>> decision
>> being based on our probably having close to zero information under
>> the
>> name of BIL and so we presumably could track down all uses of BIL.
>> If
>> this assumption is false, I would reconsider. [The two times Daphne
>> had
>> to track down all uses of a name that turned out to be bad, it was a
>> huge job and one that is impossible to feel confident in.]
>
> Agreed that BIL would be easier to replace than AMO. I also recall
> the difficulty Daphne faced in doing the replacing. Perhaps on Thurs
> we can talk about how we could estimate replacement effort.
begin transaction;
insert into census_demog
(sname, date, grp, status, cen, reference, comment)
from select 'AMO', cd.date, cd.grp, cd.status
, cd.cen, cd.reference, cd.comment
from census_demog as cdd
where cd.sname = 'BIL'
order by cd.date;
-- The order by will probably make it faster.
-- now lots more for all the other tables (census info
-- probably comes toward the end. It'd be the same
-- order you do your updates in, only reversed.)
-- Then remove the BIL stuff.
delete from census_demog where sname = 'BIL';
commit transaction;
Karl <kop at meme.com>
Free Software: "You don't pay back, you pay forward."
-- Robert A. Heinlein
More information about the Babase
mailing list