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