1 |
1 |
+ date
|
2 |
|
Fri Jan 11 05:47:34 PST 2013
|
|
2 |
Fri Jan 11 05:50:11 PST 2013
|
3 |
3 |
+ time env commit=1 env in_database=vegbien in_schema=ACAD in_table=Specimen out_database=vegbien ../../map Specimen/VegBIEN.csv
|
4 |
4 |
Processing input rows 0-99
|
5 |
5 |
Using 1 parallel CPUs
|
... | ... | |
2022 |
2022 |
DISTINCT ON ("in#11"."ACAD.Specimen.recordedBy")
|
2023 |
2023 |
"in#11".*
|
2024 |
2024 |
FROM "in#11"
|
|
2025 |
LEFT JOIN "party" ON
|
|
2026 |
"party"."source_id" = 1
|
|
2027 |
AND COALESCE("party"."organizationname", CAST('\N' AS text)) = COALESCE(NULL, CAST('\N' AS text))
|
|
2028 |
AND COALESCE("party"."fullname", CAST('\N' AS text)) = COALESCE("in#11"."ACAD.Specimen.recordedBy", CAST('\N' AS text))
|
|
2029 |
AND COALESCE("party"."surname", CAST('\N' AS text)) = COALESCE(NULL, CAST('\N' AS text))
|
|
2030 |
AND COALESCE("party"."givenname", CAST('\N' AS text)) = COALESCE(NULL, CAST('\N' AS text))
|
|
2031 |
AND COALESCE("party"."middlename", CAST('\N' AS text)) = COALESCE(NULL, CAST('\N' AS text))
|
|
2032 |
AND COALESCE("party"."suffix", CAST('\N' AS text)) = COALESCE(NULL, CAST('\N' AS text))
|
|
2033 |
WHERE "party"."party_id" IS NULL
|
2025 |
2034 |
</code></pre>
|
2026 |
2035 |
# Trying to insert new rows
|
2027 |
2036 |
<pre><code class="SQL">
|
... | ... | |
2513 |
2522 |
DISTINCT ON ("in#15"."ACAD.Specimen.institutionCode")
|
2514 |
2523 |
"in#15".*
|
2515 |
2524 |
FROM "in#15"
|
|
2525 |
LEFT JOIN "sourcelist" ON
|
|
2526 |
"sourcelist"."source_id" = 1
|
|
2527 |
AND "sourcelist"."name" = "in#15"."ACAD.Specimen.institutionCode"
|
|
2528 |
WHERE "sourcelist"."sourcelist_id" IS NULL
|
2516 |
2529 |
</code></pre>
|
2517 |
2530 |
# Trying to insert new rows
|
2518 |
2531 |
<pre><code class="SQL">
|
... | ... | |
2734 |
2747 |
DISTINCT ON ("in#17"."sourcelist_pkeys.out.sourcelist_id", "in#17"."_split(institutionCode).result")
|
2735 |
2748 |
"in#17".*
|
2736 |
2749 |
FROM "in#17"
|
|
2750 |
LEFT JOIN "sourcename" ON
|
|
2751 |
"sourcename"."sourcelist_id" = "in#17"."sourcelist_pkeys.out.sourcelist_id"
|
|
2752 |
AND "sourcename"."name" = "in#17"."_split(institutionCode).result"
|
|
2753 |
WHERE "sourcename"."sourcelist_id" IS NULL
|
2737 |
2754 |
</code></pre>
|
2738 |
2755 |
# Trying to insert new rows
|
2739 |
2756 |
<pre><code class="SQL">
|
... | ... | |
3247 |
3264 |
DISTINCT ON ("in#21"."ACAD.Specimen.identifiedBy")
|
3248 |
3265 |
"in#21".*
|
3249 |
3266 |
FROM "in#21"
|
|
3267 |
LEFT JOIN "party" ON
|
|
3268 |
"party"."source_id" = 1
|
|
3269 |
AND COALESCE("party"."organizationname", CAST('\N' AS text)) = COALESCE(NULL, CAST('\N' AS text))
|
|
3270 |
AND COALESCE("party"."fullname", CAST('\N' AS text)) = COALESCE("in#21"."ACAD.Specimen.identifiedBy", CAST('\N' AS text))
|
|
3271 |
AND COALESCE("party"."surname", CAST('\N' AS text)) = COALESCE(NULL, CAST('\N' AS text))
|
|
3272 |
AND COALESCE("party"."givenname", CAST('\N' AS text)) = COALESCE(NULL, CAST('\N' AS text))
|
|
3273 |
AND COALESCE("party"."middlename", CAST('\N' AS text)) = COALESCE(NULL, CAST('\N' AS text))
|
|
3274 |
AND COALESCE("party"."suffix", CAST('\N' AS text)) = COALESCE(NULL, CAST('\N' AS text))
|
|
3275 |
WHERE "party"."party_id" IS NULL
|
3250 |
3276 |
</code></pre>
|
3251 |
3277 |
# Trying to insert new rows
|
3252 |
3278 |
<pre><code class="SQL">
|
... | ... | |
3413 |
3439 |
DISTINCT ON ("in#22"."ACAD.Specimen.kingdom")
|
3414 |
3440 |
"in#22".*
|
3415 |
3441 |
FROM "in#22"
|
|
3442 |
LEFT JOIN "taxonlabel" ON
|
|
3443 |
COALESCE("taxonlabel"."parent_id", CAST(2147483647 AS integer)) = COALESCE(NULL, CAST(2147483647 AS integer))
|
|
3444 |
AND COALESCE("taxonlabel"."taxonepithet", CAST('\N' AS text)) = COALESCE("in#22"."ACAD.Specimen.kingdom", CAST('\N' AS text))
|
|
3445 |
AND COALESCE("taxonlabel"."rank", CAST('unknown' AS taxonrank)) = 'kingdom'
|
|
3446 |
AND "taxonlabel"."source_id" = 1
|
|
3447 |
AND COALESCE("taxonlabel"."sourceaccessioncode", CAST('\N' AS text)) = COALESCE(NULL, CAST('\N' AS text))
|
|
3448 |
AND COALESCE("taxonlabel"."taxonomicname", CAST('\N' AS text)) = COALESCE(NULL, CAST('\N' AS text))
|
|
3449 |
WHERE "taxonlabel"."taxonlabel_id" IS NULL
|
3416 |
3450 |
</code></pre>
|
3417 |
3451 |
# Trying to insert new rows
|
3418 |
3452 |
<pre><code class="SQL">
|
... | ... | |
3584 |
3618 |
DISTINCT ON ("in#23"."taxonlabel[rank='kingdom'].out.taxonlabel_id", "in#23"."ACAD.Specimen.phylum")
|
3585 |
3619 |
"in#23".*
|
3586 |
3620 |
FROM "in#23"
|
|
3621 |
LEFT JOIN "taxonlabel" ON
|
|
3622 |
COALESCE("taxonlabel"."parent_id", CAST(2147483647 AS integer)) = COALESCE("in#23"."taxonlabel[rank='kingdom'].out.taxonlabel_id", CAST(2147483647 AS integer))
|
|
3623 |
AND COALESCE("taxonlabel"."taxonepithet", CAST('\N' AS text)) = COALESCE("in#23"."ACAD.Specimen.phylum", CAST('\N' AS text))
|
|
3624 |
AND COALESCE("taxonlabel"."rank", CAST('unknown' AS taxonrank)) = 'phylum'
|
|
3625 |
AND "taxonlabel"."source_id" = 1
|
|
3626 |
AND COALESCE("taxonlabel"."sourceaccessioncode", CAST('\N' AS text)) = COALESCE(NULL, CAST('\N' AS text))
|
|
3627 |
AND COALESCE("taxonlabel"."taxonomicname", CAST('\N' AS text)) = COALESCE(NULL, CAST('\N' AS text))
|
|
3628 |
WHERE "taxonlabel"."taxonlabel_id" IS NULL
|
3587 |
3629 |
</code></pre>
|
3588 |
3630 |
# Trying to insert new rows
|
3589 |
3631 |
<pre><code class="SQL">
|
... | ... | |
3756 |
3798 |
DISTINCT ON ("in#24"."taxonlabel[rank='phylum'].out.taxonlabel_id", "in#24"."ACAD.Specimen.class")
|
3757 |
3799 |
"in#24".*
|
3758 |
3800 |
FROM "in#24"
|
|
3801 |
LEFT JOIN "taxonlabel" ON
|
|
3802 |
COALESCE("taxonlabel"."parent_id", CAST(2147483647 AS integer)) = COALESCE("in#24"."taxonlabel[rank='phylum'].out.taxonlabel_id", CAST(2147483647 AS integer))
|
|
3803 |
AND COALESCE("taxonlabel"."taxonepithet", CAST('\N' AS text)) = COALESCE("in#24"."ACAD.Specimen.class", CAST('\N' AS text))
|
|
3804 |
AND COALESCE("taxonlabel"."rank", CAST('unknown' AS taxonrank)) = 'class'
|
|
3805 |
AND "taxonlabel"."source_id" = 1
|
|
3806 |
AND COALESCE("taxonlabel"."sourceaccessioncode", CAST('\N' AS text)) = COALESCE(NULL, CAST('\N' AS text))
|
|
3807 |
AND COALESCE("taxonlabel"."taxonomicname", CAST('\N' AS text)) = COALESCE(NULL, CAST('\N' AS text))
|
|
3808 |
WHERE "taxonlabel"."taxonlabel_id" IS NULL
|
3759 |
3809 |
</code></pre>
|
3760 |
3810 |
# Trying to insert new rows
|
3761 |
3811 |
<pre><code class="SQL">
|
... | ... | |
3928 |
3978 |
DISTINCT ON ("in#25"."taxonlabel[rank='class'].out.taxonlabel_id", "in#25"."ACAD.Specimen.order")
|
3929 |
3979 |
"in#25".*
|
3930 |
3980 |
FROM "in#25"
|
|
3981 |
LEFT JOIN "taxonlabel" ON
|
|
3982 |
COALESCE("taxonlabel"."parent_id", CAST(2147483647 AS integer)) = COALESCE("in#25"."taxonlabel[rank='class'].out.taxonlabel_id", CAST(2147483647 AS integer))
|
|
3983 |
AND COALESCE("taxonlabel"."taxonepithet", CAST('\N' AS text)) = COALESCE("in#25"."ACAD.Specimen.order", CAST('\N' AS text))
|
|
3984 |
AND COALESCE("taxonlabel"."rank", CAST('unknown' AS taxonrank)) = 'order'
|
|
3985 |
AND "taxonlabel"."source_id" = 1
|
|
3986 |
AND COALESCE("taxonlabel"."sourceaccessioncode", CAST('\N' AS text)) = COALESCE(NULL, CAST('\N' AS text))
|
|
3987 |
AND COALESCE("taxonlabel"."taxonomicname", CAST('\N' AS text)) = COALESCE(NULL, CAST('\N' AS text))
|
|
3988 |
WHERE "taxonlabel"."taxonlabel_id" IS NULL
|
3931 |
3989 |
</code></pre>
|
3932 |
3990 |
# Trying to insert new rows
|
3933 |
3991 |
<pre><code class="SQL">
|
... | ... | |
4100 |
4158 |
DISTINCT ON ("in#26"."taxonlabel[rank='order'].out.taxonlabel_id", "in#26"."ACAD.Specimen.family")
|
4101 |
4159 |
"in#26".*
|
4102 |
4160 |
FROM "in#26"
|
|
4161 |
LEFT JOIN "taxonlabel" ON
|
|
4162 |
COALESCE("taxonlabel"."parent_id", CAST(2147483647 AS integer)) = COALESCE("in#26"."taxonlabel[rank='order'].out.taxonlabel_id", CAST(2147483647 AS integer))
|
|
4163 |
AND COALESCE("taxonlabel"."taxonepithet", CAST('\N' AS text)) = COALESCE("in#26"."ACAD.Specimen.family", CAST('\N' AS text))
|
|
4164 |
AND COALESCE("taxonlabel"."rank", CAST('unknown' AS taxonrank)) = 'family'
|
|
4165 |
AND "taxonlabel"."source_id" = 1
|
|
4166 |
AND COALESCE("taxonlabel"."sourceaccessioncode", CAST('\N' AS text)) = COALESCE(NULL, CAST('\N' AS text))
|
|
4167 |
AND COALESCE("taxonlabel"."taxonomicname", CAST('\N' AS text)) = COALESCE(NULL, CAST('\N' AS text))
|
|
4168 |
WHERE "taxonlabel"."taxonlabel_id" IS NULL
|
4103 |
4169 |
</code></pre>
|
4104 |
4170 |
# Trying to insert new rows
|
4105 |
4171 |
<pre><code class="SQL">
|
... | ... | |
4272 |
4338 |
DISTINCT ON ("in#27"."taxonlabel[rank='family'].out.taxonlabel_id", "in#27"."ACAD.Specimen.genus")
|
4273 |
4339 |
"in#27".*
|
4274 |
4340 |
FROM "in#27"
|
|
4341 |
LEFT JOIN "taxonlabel" ON
|
|
4342 |
COALESCE("taxonlabel"."parent_id", CAST(2147483647 AS integer)) = COALESCE("in#27"."taxonlabel[rank='family'].out.taxonlabel_id", CAST(2147483647 AS integer))
|
|
4343 |
AND COALESCE("taxonlabel"."taxonepithet", CAST('\N' AS text)) = COALESCE("in#27"."ACAD.Specimen.genus", CAST('\N' AS text))
|
|
4344 |
AND COALESCE("taxonlabel"."rank", CAST('unknown' AS taxonrank)) = 'genus'
|
|
4345 |
AND "taxonlabel"."source_id" = 1
|
|
4346 |
AND COALESCE("taxonlabel"."sourceaccessioncode", CAST('\N' AS text)) = COALESCE(NULL, CAST('\N' AS text))
|
|
4347 |
AND COALESCE("taxonlabel"."taxonomicname", CAST('\N' AS text)) = COALESCE(NULL, CAST('\N' AS text))
|
|
4348 |
WHERE "taxonlabel"."taxonlabel_id" IS NULL
|
4275 |
4349 |
</code></pre>
|
4276 |
4350 |
# Trying to insert new rows
|
4277 |
4351 |
<pre><code class="SQL">
|
... | ... | |
4444 |
4518 |
DISTINCT ON ("in#28"."taxonlabel[rank='genus'].out.taxonlabel_id", "in#28"."ACAD.Specimen.specificEpithet")
|
4445 |
4519 |
"in#28".*
|
4446 |
4520 |
FROM "in#28"
|
|
4521 |
LEFT JOIN "taxonlabel" ON
|
|
4522 |
COALESCE("taxonlabel"."parent_id", CAST(2147483647 AS integer)) = COALESCE("in#28"."taxonlabel[rank='genus'].out.taxonlabel_id", CAST(2147483647 AS integer))
|
|
4523 |
AND COALESCE("taxonlabel"."taxonepithet", CAST('\N' AS text)) = COALESCE("in#28"."ACAD.Specimen.specificEpithet", CAST('\N' AS text))
|
|
4524 |
AND COALESCE("taxonlabel"."rank", CAST('unknown' AS taxonrank)) = 'species'
|
|
4525 |
AND "taxonlabel"."source_id" = 1
|
|
4526 |
AND COALESCE("taxonlabel"."sourceaccessioncode", CAST('\N' AS text)) = COALESCE(NULL, CAST('\N' AS text))
|
|
4527 |
AND COALESCE("taxonlabel"."taxonomicname", CAST('\N' AS text)) = COALESCE(NULL, CAST('\N' AS text))
|
|
4528 |
WHERE "taxonlabel"."taxonlabel_id" IS NULL
|
4447 |
4529 |
</code></pre>
|
4448 |
4530 |
# Trying to insert new rows
|
4449 |
4531 |
<pre><code class="SQL">
|
... | ... | |
5062 |
5144 |
DISTINCT ON ("in#33"."taxonlabel[rank='species'].out.taxonlabel_id", "in#33"."ACAD.Specimen.infraspecificEpithet", "in#33"."ACAD.Specimen.taxonRank::taxonrank")
|
5063 |
5145 |
"in#33".*
|
5064 |
5146 |
FROM "in#33"
|
|
5147 |
LEFT JOIN "taxonlabel" ON
|
|
5148 |
COALESCE("taxonlabel"."parent_id", CAST(2147483647 AS integer)) = COALESCE("in#33"."taxonlabel[rank='species'].out.taxonlabel_id", CAST(2147483647 AS integer))
|
|
5149 |
AND COALESCE("taxonlabel"."taxonepithet", CAST('\N' AS text)) = COALESCE("in#33"."ACAD.Specimen.infraspecificEpithet", CAST('\N' AS text))
|
|
5150 |
AND COALESCE("taxonlabel"."rank", CAST('unknown' AS taxonrank)) = COALESCE("in#33"."ACAD.Specimen.taxonRank::taxonrank", CAST('unknown' AS taxonrank))
|
|
5151 |
AND "taxonlabel"."source_id" = 1
|
|
5152 |
AND COALESCE("taxonlabel"."sourceaccessioncode", CAST('\N' AS text)) = COALESCE(NULL, CAST('\N' AS text))
|
|
5153 |
AND COALESCE("taxonlabel"."taxonomicname", CAST('\N' AS text)) = COALESCE(NULL, CAST('\N' AS text))
|
|
5154 |
WHERE "taxonlabel"."taxonlabel_id" IS NULL
|
5065 |
5155 |
</code></pre>
|
5066 |
5156 |
# Trying to insert new rows
|
5067 |
5157 |
<pre><code class="SQL">
|
... | ... | |
6206 |
6296 |
DISTINCT ON ("in#42"."_merge_prefix(_alt(1=scientificName, 2=_join_words(1=_jo.result")
|
6207 |
6297 |
"in#42".*
|
6208 |
6298 |
FROM "in#42"
|
|
6299 |
LEFT JOIN "taxonlabel" ON
|
|
6300 |
"taxonlabel"."source_id" = 1
|
|
6301 |
AND COALESCE("taxonlabel"."taxonomicname", CAST('\N' AS text)) = COALESCE("in#42"."_merge_prefix(_alt(1=scientificName, 2=_join_words(1=_jo.result", CAST('\N' AS text))
|
|
6302 |
WHERE "taxonlabel"."taxonlabel_id" IS NULL
|
6209 |
6303 |
</code></pre>
|
6210 |
6304 |
# Trying to insert new rows
|
6211 |
6305 |
<pre><code class="SQL">
|
... | ... | |
6341 |
6435 |
DISTINCT ON ("in#43"."taxonlabel[rank=taxonRank]#1.out.taxonlabel_id")
|
6342 |
6436 |
"in#43".*
|
6343 |
6437 |
FROM "in#43"
|
|
6438 |
LEFT JOIN "taxonverbatim" ON
|
|
6439 |
"taxonverbatim"."taxonlabel_id" = "in#43"."taxonlabel[rank=taxonRank]#1.out.taxonlabel_id"
|
|
6440 |
AND COALESCE("taxonverbatim"."morphospecies", CAST('\N' AS text)) = COALESCE(NULL, CAST('\N' AS text))
|
|
6441 |
WHERE "taxonverbatim"."taxonverbatim_id" IS NULL
|
6344 |
6442 |
</code></pre>
|
6345 |
6443 |
# Trying to insert new rows
|
6346 |
6444 |
<pre><code class="SQL">
|
... | ... | |
7029 |
7127 |
DISTINCT ON ("in#47"."_nullIf(decimalLatitude).result::double", "in#47"."_nullIf(decimalLongitude).result::double")
|
7030 |
7128 |
"in#47".*
|
7031 |
7129 |
FROM "in#47"
|
|
7130 |
LEFT JOIN "coordinates" ON
|
|
7131 |
"coordinates"."source_id" = 1
|
|
7132 |
AND "coordinates"."latitude_deg" = "in#47"."_nullIf(decimalLatitude).result::double"
|
|
7133 |
AND "coordinates"."longitude_deg" = "in#47"."_nullIf(decimalLongitude).result::double"
|
|
7134 |
AND COALESCE("coordinates"."verbatimlatitude", CAST('\N' AS text)) = COALESCE(NULL, CAST('\N' AS text))
|
|
7135 |
AND COALESCE("coordinates"."verbatimlongitude", CAST('\N' AS text)) = COALESCE(NULL, CAST('\N' AS text))
|
|
7136 |
AND COALESCE("coordinates"."verbatimcoordinates", CAST('\N' AS text)) = COALESCE(NULL, CAST('\N' AS text))
|
|
7137 |
AND COALESCE("coordinates"."footprintgeometry_dwc", CAST('\N' AS text)) = COALESCE(NULL, CAST('\N' AS text))
|
|
7138 |
WHERE "coordinates"."coordinates_id" IS NULL
|
7032 |
7139 |
</code></pre>
|
7033 |
7140 |
# Trying to insert new rows
|
7034 |
7141 |
<pre><code class="SQL">
|
... | ... | |
7529 |
7636 |
DISTINCT ON ("in#50"."_nullIf(decimalLatitude)#1.result::double", "in#50"."_nullIf(decimalLongitude)#1.result::double")
|
7530 |
7637 |
"in#50".*
|
7531 |
7638 |
FROM "in#50"
|
|
7639 |
LEFT JOIN "coordinates" ON
|
|
7640 |
"coordinates"."source_id" = 25
|
|
7641 |
AND "coordinates"."latitude_deg" = "in#50"."_nullIf(decimalLatitude)#1.result::double"
|
|
7642 |
AND "coordinates"."longitude_deg" = "in#50"."_nullIf(decimalLongitude)#1.result::double"
|
|
7643 |
AND COALESCE("coordinates"."verbatimlatitude", CAST('\N' AS text)) = COALESCE(NULL, CAST('\N' AS text))
|
|
7644 |
AND COALESCE("coordinates"."verbatimlongitude", CAST('\N' AS text)) = COALESCE(NULL, CAST('\N' AS text))
|
|
7645 |
AND COALESCE("coordinates"."verbatimcoordinates", CAST('\N' AS text)) = COALESCE(NULL, CAST('\N' AS text))
|
|
7646 |
AND COALESCE("coordinates"."footprintgeometry_dwc", CAST('\N' AS text)) = COALESCE(NULL, CAST('\N' AS text))
|
|
7647 |
WHERE "coordinates"."coordinates_id" IS NULL
|
7532 |
7648 |
</code></pre>
|
7533 |
7649 |
# Trying to insert new rows
|
7534 |
7650 |
<pre><code class="SQL">
|
... | ... | |
7664 |
7780 |
DISTINCT ON ("in#51"."ACAD.Specimen.country", "in#51"."ACAD.Specimen.stateProvince", "in#51"."ACAD.Specimen.county", "in#51"."coordinates_pkeys#1.out.coordinates_id")
|
7665 |
7781 |
"in#51".*
|
7666 |
7782 |
FROM "in#51"
|
|
7783 |
LEFT JOIN "place" ON
|
|
7784 |
"place"."source_id" = 25
|
|
7785 |
AND COALESCE("place"."continent", CAST('\N' AS text)) = COALESCE(NULL, CAST('\N' AS text))
|
|
7786 |
AND COALESCE("place"."country", CAST('\N' AS text)) = COALESCE("in#51"."ACAD.Specimen.country", CAST('\N' AS text))
|
|
7787 |
AND COALESCE("place"."stateprovince", CAST('\N' AS text)) = COALESCE("in#51"."ACAD.Specimen.stateProvince", CAST('\N' AS text))
|
|
7788 |
AND COALESCE("place"."county", CAST('\N' AS text)) = COALESCE("in#51"."ACAD.Specimen.county", CAST('\N' AS text))
|
|
7789 |
AND COALESCE("place"."coordinates_id", CAST(2147483647 AS integer)) = COALESCE("in#51"."coordinates_pkeys#1.out.coordinates_id", CAST(2147483647 AS integer))
|
|
7790 |
WHERE "place"."place_id" IS NULL
|
7667 |
7791 |
</code></pre>
|
7668 |
7792 |
# Trying to insert new rows
|
7669 |
7793 |
<pre><code class="SQL">
|
... | ... | |
7851 |
7975 |
DISTINCT ON ("in#52"."ACAD.Specimen.continent", "in#52"."ACAD.Specimen.country", "in#52"."ACAD.Specimen.stateProvince", "in#52"."ACAD.Specimen.county", "in#52"."coordinates_pkeys.out.coordinates_id")
|
7852 |
7976 |
"in#52".*
|
7853 |
7977 |
FROM "in#52"
|
|
7978 |
LEFT JOIN "place" ON
|
|
7979 |
"place"."source_id" = 1
|
|
7980 |
AND COALESCE("place"."continent", CAST('\N' AS text)) = COALESCE("in#52"."ACAD.Specimen.continent", CAST('\N' AS text))
|
|
7981 |
AND COALESCE("place"."country", CAST('\N' AS text)) = COALESCE("in#52"."ACAD.Specimen.country", CAST('\N' AS text))
|
|
7982 |
AND COALESCE("place"."stateprovince", CAST('\N' AS text)) = COALESCE("in#52"."ACAD.Specimen.stateProvince", CAST('\N' AS text))
|
|
7983 |
AND COALESCE("place"."county", CAST('\N' AS text)) = COALESCE("in#52"."ACAD.Specimen.county", CAST('\N' AS text))
|
|
7984 |
AND COALESCE("place"."coordinates_id", CAST(2147483647 AS integer)) = COALESCE("in#52"."coordinates_pkeys.out.coordinates_id", CAST(2147483647 AS integer))
|
|
7985 |
WHERE "place"."place_id" IS NULL
|
7854 |
7986 |
</code></pre>
|
7855 |
7987 |
# Trying to insert new rows
|
7856 |
7988 |
<pre><code class="SQL">
|
... | ... | |
7989 |
8121 |
</code></pre>Inserted 1325 new rows into database
|
7990 |
8122 |
Processed 100 input rows
|
7991 |
8123 |
Encountered 0 error(s)
|
7992 |
|
11.82 real 4.23 user 0.45 sys
|
|
8124 |
12.05 real 4.37 user 0.45 sys
|
sql_io.py: put_table(): DuplicateKeyException: Uniquifying input table to avoid internal duplicate keys: Also filter out duplicate rows in the out_table, so that they don't create duplicate key errors and the resulting index holes