Project

General

Profile

Bug #965

Updated by Aaron Marcuse-Kubitza over 9 years ago

h3. problem 

 * this applies to 358 @location@ rows: 

 
 <pre><code class="SQL"> 
 SELECT * FROM location 
 WHERE 
     source_id = (SELECT source_by_shortname('VegBank')) 
 AND authorlocationcode IS NULL 
 </code></pre> 

 
 * these @location@ rows are _not_ present in the input data: 

 
 <pre><code class="SQL"> 
 SELECT * FROM "VegBank".plot 
 WHERE "locationID" IN 
 ( 
 SELECT sourceaccessioncode::integer FROM location 
 WHERE 
     source_id = (SELECT source_by_shortname('VegBank')) 
 AND authorlocationcode IS NULL 
 ) 
 ; -- returns no rows 
 </code></pre> 

 this </code></pre>this is most likely due to a missing foreign key at the time the embargoed plots are cascadingly deleted

Back