MY UPDATE STATEMENTS ARE <div><span class="Apple-style-span" style="font-family: arial, tahoma, verdana, helvetica, sans-serif, serif; font-size: 13px; "><pre style="font-size: 12px; ">UPDATE RANKS SET SNAME = 'AMO' WHERE SNAME ='BIL';
UPDATE PARTS SET SNAME = 'AMO' WHERE SNAME ='BIL';</pre></span><br><div class="gmail_quote">On Wed, May 5, 2010 at 4:49 PM, Karl O. Pinc <span dir="ltr"><<a href="mailto:kop@meme.com">kop@meme.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">On 05/05/2010 03:39:44 PM, Niki Learn wrote:<br>
> Yes, you have to be babase_admin to empty members. I do it every<br>
> update.<br>
> Actually I didn't even try NOT emptying members - I just assumed it<br>
> would be<br>
> necessary since we were messing with census data. But then it threw<br>
> errors<br>
> when I tried to change the census entries to manual because the<br>
> latter<br>
> part<br>
> of Amok's life had not been rebuilt yet in members so it didn't like<br>
> him<br>
> having ranks and stuff when he wasn't listed as being in the group.<br>
> Do you<br>
> think we could have skipped the members part.<br>
><br>
> We can't delete Billy's census data until the end, after all his<br>
> ranks<br>
> and<br>
> parts data has been switched over to Amok. We can't switch that over<br>
> until<br>
> Amok is in census. It is a circle.<br>
<br>
There's no restriction on having Amok and Billy be censused in<br>
the same group. So I'd expect you'd add Amok's census entries<br>
first, then move all the data by deleting stuff from Billy<br>
and adding it to Amok, then delete Billy's census entries<br>
last.<br>
<br>
The basic principle would be to delete in an order that's<br>
opposite from the order in which you add.<br>
<br>
I guess if there is a way to do<br>
> all<br>
> three simultaneously then we wouldn't need as many steps. But I got<br>
> rid of<br>
> most of the manual census entries anyway so whatever. This worked so<br>
> we are<br>
> happy.<br>
<br>
Yes. You don't care so much about deleting Billy's members because<br>
you know he's going away so you don't care about errors. It's<br>
just a little spooky having to be babase_admin. Sort of like<br>
resorting to a hammer. Nothing wrong with a hammer though,<br>
it's a fine tool. :-)<br>
<div class="im"><br>
><br>
> -----Original Message-----<br>
> From: Karl O. Pinc [mailto:<a href="mailto:kop@meme.com">kop@meme.com</a>]<br>
> Sent: Wednesday, May 05, 2010 4:26 PM<br>
> To: Niki Learn<br>
> Subject: Re: manual census entries<br>
><br>
</div><div class="im">> On 05/05/2010 03:20:10 PM, Niki Learn wrote:<br>
> > I guess we should make sure each office has a full list of the<br>
> steps<br>
> > in case<br>
> > we ever have to do this again. Most of them aren't in here though.<br>
> > Shall<br>
> > we compile a list of the steps and send that to the list for<br>
> > archiving?<br>
> > Here's what I have:<br>
> ><br>
> > Empty members<br>
><br>
</div>> Wouldn't you have to be babase_admin to do this?<br>
><br>
> As an alternative why not delete all the<br>
> census rows?<br>
><br>
><br>
><br>
><br>
> Karl <<a href="mailto:kop@meme.com">kop@meme.com</a>><br>
> Free Software: "You don't pay back, you pay forward."<br>
> -- Robert A. Heinlein<br>
><br>
><br>
><br>
><br>
<br>
<br>
<br>
<br>
Karl <<a href="mailto:kop@meme.com">kop@meme.com</a>><br>
Free Software: "You don't pay back, you pay forward."<br>
-- Robert A. Heinlein<br>
<br>
<br>
_______________________________________________<br>
Babase mailing list<br>
<a href="mailto:Babase@www.eco.princeton.edu">Babase@www.eco.princeton.edu</a><br>
<a href="http://www.eco.princeton.edu/mailman/listinfo/babase" target="_blank">http://www.eco.princeton.edu/mailman/listinfo/babase</a><br>
</blockquote></div><br><br clear="all"><br>-- <br>- -<br>Lacey K. Maryott Roerish<br>Alberts Lab<br>Department of Biology<br>Duke University<br>ph: 919-660-7306<br>fax: 919-660-7293<br><a href="mailto:Lacey.Maryott@duke.edu">Lacey.Maryott@duke.edu</a><br>
</div>