[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