Re: [Treebase-devel] Some results of testing with a user

[William P. <wil...@ya...>]

On Mar 19, 2010, at 3:40 PM, Hilmar Lapp wrote:

> Sounds good to me.


Okay, I just did it. I checked back with study_id 10051, and it seems to have fixed the problem. 

Unless Vladimir has other placeholder study ids used in the migration scripts, this fixes it. 

Below is the query for Jon to run on production. 

bp




begin work;

UPDATE taxonlabelset SET study_id = mx.study_id
FROM matrix mx JOIN taxonlabelset tls USING (taxonlabelset_id)
WHERE tls.study_id = 2264
AND mx.study_id <> 2264
AND taxonlabelset.taxonlabelset_id = tls.taxonlabelset_id

-- should result in 570 changes

commit;