[Babase] Merging JPSAMPS with FPSAMPS (and JPNEIGHBORS with FPNEIGHBORS)

Karl O. Pinc babase@www.eco.princeton.edu
Sun, 10 Oct 2004 20:11:27 -0500


On 2004.10.09 09:12 Susan Alberts wrote:
>> 
>> 
>> We've less than 100,000 JPSAMPS, so I've added 100,000 to the FPSAMPS
>> and FPNEIGHBORS Fpid so the ids don't conflict when they're all
>> put into one table.  Does anybody care about the old ids at all?
>> I could add 1,000,000 to the FPSAMPS ids just to make the new id
>> the old id with a 1 on the left.
> 
> 
> I don't think anyone has used the old IDs in queries yet, so perhaps 
> this is not an issue but again, others should comment. I think that 
> even if they have been used in a query, it would be relatively easy 
> to change it. My opinion is that we should not worry about it, but 
> someone closer to the database (especially Daphne) should comment.

I would not expect the ids to be used for other than connecting
one table to another, that is the specific values would be
used for computer purposes but would not be otherwise recorded.
But then, I'm not using the database.

Karl <kop@meme.com>
Free Software:  "You don't pay back, you pay forward."
                  -- Robert A. Heinlein