smnorris / fwapg

PostgreSQL tools for working with British Columbia's Freshwater Atlas
https://smnorris.github.io/fwapg
MIT License
9 stars 5 forks source link

`sql/tables/spatial/large/fwa_linear_boundaries_sp.sql ` duplicate key value violates unique constraint #129

Closed NewGraphEnvironment closed 1 year ago

NewGraphEnvironment commented 1 year ago

Thinking I tried to build on top of an old DB which likey was made with pg_dump perhaps --schema-only before --data-only. Will try nuking the whole thing and starting over.

for wsg in ADMS ALBN ATLL ATNA BABL BABR BARR BBAR BEAV BELA BIGC BLAR BLUR BONP BOWR BRID BRKS BULK BULL CAMB CANO CARP CARR CHES CHIL CHIR CHUK CHWK CLAY CLRH CLWR COAL COLR COMX COTR COWN CRKD CRYL DEAD DEAL DEAR DOGC DRIR DUNC DUNE ELKR EUCH EUCL FINA FINL FIRE FONT FOXR FRAN FRCN FROG GATA GLAR GOLD GRAI GRNL GUIC HARR HAYR HERR HOLB HOMA HORS INGR INKR ISKR JENR JERV KAHN KAKC KCHL KEEC KETL KHOR KHTZ KINR KISK KISP KITL KITR KLAR KLIN KLUM KNIG KOTL KOTR KSHR KTSU KUMR KUSR LARL LBIR LBTN LCHL LCHR LDEN LEUT LFRA LFRT LHAF LIAR LILL LISR LKEC LKEL LMUS LNAR LNIC LNRS LNTH LOMI LPCE LPET LPRO LRAN LRDO LSAL LSIK LSKE LSTR LTRE MAHD MBNK MCGR MDEA MESC MESI MFRA MFRT MIDR MILL MMUS MORI MORK MORR MPRO MSKE MSTR MURR MURT MUSK NAHR NAKR NARC NASC NASR NATR NAZR NBNK NECL NECR NEVI NICL NIEL NIMP OKAN OSPK OWIK PARA PARK PARS PCEA PINE PITR PORI QUES REVL SAHD SAHT SAJR SALM SALR SANJ SETN SEYM SHEK SHER SHUL SIML SKGT SLOC SMAR SMOK SPAT SQAM STHM STIR STUL STUR SUST SWIR TABR TAHR TAHS TAKL TASR TATR TAYR TESR THOM TOAD TOBA TOOD TSAY TSEA TSIT TURN TUTR TUYR TWAC UARL UBIR UBTN UCHR UDEN UEUT UFRA UFRT UHAF UISR UJER UKEC ULRD UMUS UNAR UNRS UNTH UNUR UOMI UPCE UPET UPRO USHU USIK USKE USTK UTRE VICT WILL WORC ZYMO ; do \
    set -e ; psql postgresql://postgres@localhost:5432/newgraph -v ON_ERROR_STOP=1 -f sql/tables/spatial/large/fwa_linear_boundaries_sp.sql -v wsg=$wsg ; \
done
DELETE 8835
INSERT 0 8835
DELETE 7980
INSERT 0 7980
DELETE 18391
INSERT 0 18391
DELETE 18342
INSERT 0 18342
DELETE 28568
INSERT 0 28568
DELETE 24233
INSERT 0 24233
DELETE 8527
INSERT 0 8527
DELETE 7488
INSERT 0 7488
DELETE 21442
INSERT 0 21442
DELETE 5786
INSERT 0 5786
DELETE 15451
INSERT 0 15451
DELETE 22774
INSERT 0 22774
DELETE 11139
INSERT 0 11139
DELETE 16053
INSERT 0 16053
DELETE 12173
INSERT 0 12173
DELETE 10266
INSERT 0 10266
DELETE 3212
INSERT 0 3212
DELETE 23444
INSERT 0 23444
DELETE 3718
INSERT 0 3718
DELETE 4305
INSERT 0 4305
DELETE 3049
INSERT 0 3049
DELETE 14782
INSERT 0 14782
DELETE 6207
INSERT 0 6207
DELETE 10570
INSERT 0 10570
DELETE 13253
INSERT 0 13253
DELETE 9903
INSERT 0 9903
DELETE 6704
INSERT 0 6704
DELETE 1624
INSERT 0 1624
DELETE 5502
INSERT 0 5502
DELETE 12434
INSERT 0 12434
DELETE 18953
INSERT 0 18953
DELETE 29098
INSERT 0 29098
DELETE 10261
INSERT 0 10261
DELETE 6543
INSERT 0 6543
DELETE 21023
INSERT 0 21023
DELETE 4585
INSERT 0 4585
DELETE 19106
INSERT 0 19106
DELETE 5063
INSERT 0 5063
DELETE 12104
INSERT 0 12104
DELETE 14038
INSERT 0 14038
DELETE 19525
INSERT 0 19525
DELETE 8536
INSERT 0 8536
DELETE 11944
INSERT 0 11944
DELETE 4963
INSERT 0 4963
DELETE 22814
INSERT 0 22814
DELETE 7587
INSERT 0 7587
DELETE 12254
INSERT 0 12254
DELETE 24546
INSERT 0 24546
DELETE 14123
INSERT 0 14123
DELETE 9665
INSERT 0 9665
DELETE 20412
INSERT 0 20412
DELETE 48036
INSERT 0 48036
DELETE 11237
INSERT 0 11237
DELETE 37518
INSERT 0 37518
DELETE 5224
INSERT 0 5224
DELETE 12466
INSERT 0 12466
DELETE 7201
INSERT 0 7201
DELETE 12336
INSERT 0 12336
DELETE 5010
INSERT 0 5010
DELETE 43577
INSERT 0 43577
DELETE 18997
INSERT 0 18997
DELETE 6682
INSERT 0 6682
DELETE 3955
INSERT 0 3955
DELETE 15664
INSERT 0 15664
DELETE 7921
INSERT 0 7921
DELETE 2084
INSERT 0 2084
DELETE 16352
INSERT 0 16352
DELETE 15101
INSERT 0 15101
DELETE 11430
INSERT 0 11430
DELETE 20355
INSERT 0 20355
DELETE 10187
INSERT 0 10187
DELETE 5732
INSERT 0 5732
DELETE 6502
INSERT 0 6502
DELETE 20055
INSERT 0 20055
DELETE 7531
INSERT 0 7531
DELETE 42975
INSERT 0 42975
DELETE 13696
INSERT 0 13696
DELETE 14875
INSERT 0 14875
DELETE 13969
INSERT 0 13969
DELETE 7815
INSERT 0 7815
DELETE 9469
INSERT 0 9469
DELETE 17454
INSERT 0 17454
DELETE 14492
INSERT 0 14492
DELETE 11900
INSERT 0 11900
DELETE 9290
INSERT 0 9290
DELETE 12128
INSERT 0 12128
DELETE 21272
INSERT 0 21272
DELETE 11388
INSERT 0 11388
DELETE 11230
INSERT 0 11230
DELETE 7195
INSERT 0 7195
DELETE 5953
INSERT 0 5953
DELETE 7053
INSERT 0 7053
DELETE 15355
INSERT 0 15355
DELETE 10728
INSERT 0 10728
DELETE 12529
INSERT 0 12529
DELETE 4992
INSERT 0 4992
DELETE 8326
INSERT 0 8326
DELETE 39906
INSERT 0 39906
DELETE 18644
INSERT 0 18644
DELETE 0
psql:sql/tables/spatial/large/fwa_linear_boundaries_sp.sql:35: ERROR:  duplicate key value violates unique constraint "fwa_linear_boundaries_sp_pkey"
DETAIL:  Key (linear_feature_id)=(832474943) already exists.
make: *** [Makefile:156: .make/fwa_linear_boundaries_sp] Error 3
NewGraphEnvironment commented 1 year ago

as per the docs

"To apply updates, full table refreshes are required." so

make clean_targets
make clean_db
make