[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