[Babase] AMOK Questions

Susan Alberts alberts at duke.edu
Mon Aug 4 10:42:01 EDT 2008


Thanks Karl, no we don't need you for the conference call, we can do  
what we need to this week (which includes various other small babase- 
related things) without "the big guns". We'll let you know if we need  
a call with you.
Susan

On Aug 4, 2008, at 10:21 AM, Karl O. Pinc wrote:

>
> 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
>
> _______________________________________________
> Babase mailing list
> Babase at www.eco.princeton.edu
> http://www.eco.princeton.edu/mailman/listinfo/babase

--------------------------------------------------------
Susan Alberts, Dept of Biology, Duke University, Box 90338, Durham NC  
27708, 919-660-7272 (Ph), 919-660-7293 (Fax)



More information about the Babase mailing list