Revision 14379
Added by Aaron Marcuse-Kubitza over 10 years ago
| trunk/inputs/.TNRS/schema.sql | ||
|---|---|---|
| 615 | 615 |
# rename column |
| 616 | 616 |
# rename CHECK constraint |
| 617 | 617 |
SELECT util.derived_cols_update(''"TNRS".taxon_match''::regclass);
|
| 618 |
|
|
| 619 |
to drop: |
|
| 620 |
SELECT util.drop_derived_col((''"TNRS".taxon_match'', ''[parsed_]morphospecies[_suffix]__@Brad__.morphosp@vegpath.org'')::util.col);
|
|
| 621 |
-- DROP __ CASCADE doesn''t work when there are dependent views |
|
| 618 | 622 |
'; |
| 619 | 623 |
|
| 620 | 624 |
|
| ... | ... | |
| 635 | 639 |
# rename column |
| 636 | 640 |
# rename CHECK constraint |
| 637 | 641 |
SELECT util.derived_cols_update(''"TNRS".taxon_match''::regclass);
|
| 642 |
|
|
| 643 |
to drop: |
|
| 644 |
SELECT util.drop_derived_col((''"TNRS".taxon_match'', ''[matched_]species[_binomial]~(-Accepted_-)__@TNRS__@vegpath.org'')::util.col);
|
|
| 645 |
-- DROP __ CASCADE doesn''t work when there are dependent views |
|
| 638 | 646 |
'; |
| 639 | 647 |
|
| 640 | 648 |
|
| ... | ... | |
| 655 | 663 |
# rename column |
| 656 | 664 |
# rename CHECK constraint |
| 657 | 665 |
SELECT util.derived_cols_update(''"TNRS".taxon_match''::regclass);
|
| 666 |
|
|
| 667 |
to drop: |
|
| 668 |
SELECT util.drop_derived_col((''"TNRS".taxon_match'', ''matched~Name[_no_author]___@TNRS__@vegpath.org'')::util.col);
|
|
| 669 |
-- DROP __ CASCADE doesn''t work when there are dependent views |
|
| 658 | 670 |
'; |
| 659 | 671 |
|
| 660 | 672 |
|
| ... | ... | |
| 675 | 687 |
# rename column |
| 676 | 688 |
# rename CHECK constraint |
| 677 | 689 |
SELECT util.derived_cols_update(''"TNRS".taxon_match''::regclass);
|
| 690 |
|
|
| 691 |
to drop: |
|
| 692 |
SELECT util.drop_derived_col((''"TNRS".taxon_match'', ''[matched_]scientificName[_with_author]__@DwC__@vegpath.org'')::util.col);
|
|
| 693 |
-- DROP __ CASCADE doesn''t work when there are dependent views |
|
| 678 | 694 |
'; |
| 679 | 695 |
|
| 680 | 696 |
|
| ... | ... | |
| 695 | 711 |
# rename column |
| 696 | 712 |
# rename CHECK constraint |
| 697 | 713 |
SELECT util.derived_cols_update(''"TNRS".taxon_match''::regclass);
|
| 714 |
|
|
| 715 |
to drop: |
|
| 716 |
SELECT util.drop_derived_col((''"TNRS".taxon_match'', ''matched_has_accepted'')::util.col);
|
|
| 717 |
-- DROP __ CASCADE doesn''t work when there are dependent views |
|
| 698 | 718 |
'; |
| 699 | 719 |
|
| 700 | 720 |
|
| ... | ... | |
| 723 | 743 |
# rename column |
| 724 | 744 |
# rename CHECK constraint |
| 725 | 745 |
SELECT util.derived_cols_update(''"TNRS".taxon_match''::regclass);
|
| 746 |
|
|
| 747 |
to drop: |
|
| 748 |
SELECT util.drop_derived_col((''"TNRS".taxon_match'', ''Accepted_family__@TNRS__@vegpath.org'')::util.col);
|
|
| 749 |
-- DROP __ CASCADE doesn''t work when there are dependent views |
|
| 726 | 750 |
'; |
| 727 | 751 |
|
| 728 | 752 |
|
| ... | ... | |
| 743 | 767 |
# rename column |
| 744 | 768 |
# rename CHECK constraint |
| 745 | 769 |
SELECT util.derived_cols_update(''"TNRS".taxon_match''::regclass);
|
| 770 |
|
|
| 771 |
to drop: |
|
| 772 |
SELECT util.drop_derived_col((''"TNRS".taxon_match'', ''Accepted_species[_binomial]__@TNRS__@vegpath.org'')::util.col);
|
|
| 773 |
-- DROP __ CASCADE doesn''t work when there are dependent views |
|
| 746 | 774 |
'; |
| 747 | 775 |
|
| 748 | 776 |
|
| ... | ... | |
| 763 | 791 |
# rename column |
| 764 | 792 |
# rename CHECK constraint |
| 765 | 793 |
SELECT util.derived_cols_update(''"TNRS".taxon_match''::regclass);
|
| 794 |
|
|
| 795 |
to drop: |
|
| 796 |
SELECT util.drop_derived_col((''"TNRS".taxon_match'', ''__accepted_{genus,specific_epithet,infra_{rank,epithet}}'')::util.col);
|
|
| 797 |
-- DROP __ CASCADE doesn''t work when there are dependent views |
|
| 766 | 798 |
'; |
| 767 | 799 |
|
| 768 | 800 |
|
| ... | ... | |
| 783 | 815 |
# rename column |
| 784 | 816 |
# rename CHECK constraint |
| 785 | 817 |
SELECT util.derived_cols_update(''"TNRS".taxon_match''::regclass);
|
| 818 |
|
|
| 819 |
to drop: |
|
| 820 |
SELECT util.drop_derived_col((''"TNRS".taxon_match'', ''[accepted_]genus__@DwC__@vegpath.org'')::util.col);
|
|
| 821 |
-- DROP __ CASCADE doesn''t work when there are dependent views |
|
| 786 | 822 |
'; |
| 787 | 823 |
|
| 788 | 824 |
|
| ... | ... | |
| 803 | 839 |
# rename column |
| 804 | 840 |
# rename CHECK constraint |
| 805 | 841 |
SELECT util.derived_cols_update(''"TNRS".taxon_match''::regclass);
|
| 842 |
|
|
| 843 |
to drop: |
|
| 844 |
SELECT util.drop_derived_col((''"TNRS".taxon_match'', ''[accepted_]specificEpithet__@DwC__@vegpath.org'')::util.col);
|
|
| 845 |
-- DROP __ CASCADE doesn''t work when there are dependent views |
|
| 806 | 846 |
'; |
| 807 | 847 |
|
| 808 | 848 |
|
| ... | ... | |
| 831 | 871 |
# rename column |
| 832 | 872 |
# rename CHECK constraint |
| 833 | 873 |
SELECT util.derived_cols_update(''"TNRS".taxon_match''::regclass);
|
| 874 |
|
|
| 875 |
to drop: |
|
| 876 |
SELECT util.drop_derived_col((''"TNRS".taxon_match'', ''[accepted_]morphospecies[_binomial]__@Brad__.TNRS@vegpath.org'')::util.col);
|
|
| 877 |
-- DROP __ CASCADE doesn''t work when there are dependent views |
|
| 834 | 878 |
'; |
| 835 | 879 |
|
| 836 | 880 |
|
| ... | ... | |
| 851 | 895 |
# rename column |
| 852 | 896 |
# rename CHECK constraint |
| 853 | 897 |
SELECT util.derived_cols_update(''"TNRS".taxon_match''::regclass);
|
| 898 |
|
|
| 899 |
to drop: |
|
| 900 |
SELECT util.drop_derived_col((''"TNRS".taxon_match'', ''__accepted_infraspecific_label'')::util.col);
|
|
| 901 |
-- DROP __ CASCADE doesn''t work when there are dependent views |
|
| 854 | 902 |
'; |
| 855 | 903 |
|
| 856 | 904 |
|
| ... | ... | |
| 871 | 919 |
# rename column |
| 872 | 920 |
# rename CHECK constraint |
| 873 | 921 |
SELECT util.derived_cols_update(''"TNRS".taxon_match''::regclass);
|
| 922 |
|
|
| 923 |
to drop: |
|
| 924 |
SELECT util.drop_derived_col((''"TNRS".taxon_match'', ''__accepted_infraspecific_{rank,epithet}'')::util.col);
|
|
| 925 |
-- DROP __ CASCADE doesn''t work when there are dependent views |
|
| 874 | 926 |
'; |
| 875 | 927 |
|
| 876 | 928 |
|
| ... | ... | |
| 891 | 943 |
# rename column |
| 892 | 944 |
# rename CHECK constraint |
| 893 | 945 |
SELECT util.derived_cols_update(''"TNRS".taxon_match''::regclass);
|
| 946 |
|
|
| 947 |
to drop: |
|
| 948 |
SELECT util.drop_derived_col((''"TNRS".taxon_match'', ''[accepted_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org'')::util.col);
|
|
| 949 |
-- DROP __ CASCADE doesn''t work when there are dependent views |
|
| 894 | 950 |
'; |
| 895 | 951 |
|
| 896 | 952 |
|
| ... | ... | |
| 911 | 967 |
# rename column |
| 912 | 968 |
# rename CHECK constraint |
| 913 | 969 |
SELECT util.derived_cols_update(''"TNRS".taxon_match''::regclass);
|
| 970 |
|
|
| 971 |
to drop: |
|
| 972 |
SELECT util.drop_derived_col((''"TNRS".taxon_match'', ''[accepted_]infraspecificEpithet__@DwC__@vegpath.org'')::util.col);
|
|
| 973 |
-- DROP __ CASCADE doesn''t work when there are dependent views |
|
| 914 | 974 |
'; |
| 915 | 975 |
|
| 916 | 976 |
|
| ... | ... | |
| 931 | 991 |
# rename column |
| 932 | 992 |
# rename CHECK constraint |
| 933 | 993 |
SELECT util.derived_cols_update(''"TNRS".taxon_match''::regclass);
|
| 994 |
|
|
| 995 |
to drop: |
|
| 996 |
SELECT util.drop_derived_col((''"TNRS".taxon_match'', ''[accepted_]scientificName[_with_author]__@DwC__@vegpath.org'')::util.col);
|
|
| 997 |
-- DROP __ CASCADE doesn''t work when there are dependent views |
|
| 934 | 998 |
'; |
| 935 | 999 |
|
| 936 | 1000 |
|
| ... | ... | |
| 951 | 1015 |
# rename column |
| 952 | 1016 |
# rename CHECK constraint |
| 953 | 1017 |
SELECT util.derived_cols_update(''"TNRS".taxon_match''::regclass);
|
| 1018 |
|
|
| 1019 |
to drop: |
|
| 1020 |
SELECT util.drop_derived_col((''"TNRS".taxon_match'', ''[scrubbed_]taxonomicStatus__@DwC__@vegpath.org'')::util.col);
|
|
| 1021 |
-- DROP __ CASCADE doesn''t work when there are dependent views |
|
| 954 | 1022 |
'; |
| 955 | 1023 |
|
| 956 | 1024 |
|
| ... | ... | |
| 977 | 1045 |
# rename column |
| 978 | 1046 |
# rename CHECK constraint |
| 979 | 1047 |
SELECT util.derived_cols_update(''"TNRS".taxon_match''::regclass);
|
| 1048 |
|
|
| 1049 |
to drop: |
|
| 1050 |
SELECT util.drop_derived_col((''"TNRS".taxon_match'', ''[scrubbed_]taxonRank__@DwC__@vegpath.org'')::util.col);
|
|
| 1051 |
-- DROP __ CASCADE doesn''t work when there are dependent views |
|
| 980 | 1052 |
'; |
| 981 | 1053 |
|
| 982 | 1054 |
|
| ... | ... | |
| 1003 | 1075 |
# rename column |
| 1004 | 1076 |
# rename CHECK constraint |
| 1005 | 1077 |
SELECT util.derived_cols_update(''"TNRS".taxon_match''::regclass);
|
| 1078 |
|
|
| 1079 |
to drop: |
|
| 1080 |
SELECT util.drop_derived_col((''"TNRS".taxon_match'', ''[scrubbed_]family~(-Accepted_-)__@TNRS__@vegpath.org'')::util.col);
|
|
| 1081 |
-- DROP __ CASCADE doesn''t work when there are dependent views |
|
| 1006 | 1082 |
'; |
| 1007 | 1083 |
|
| 1008 | 1084 |
|
| ... | ... | |
| 1029 | 1105 |
# rename column |
| 1030 | 1106 |
# rename CHECK constraint |
| 1031 | 1107 |
SELECT util.derived_cols_update(''"TNRS".taxon_match''::regclass);
|
| 1108 |
|
|
| 1109 |
to drop: |
|
| 1110 |
SELECT util.drop_derived_col((''"TNRS".taxon_match'', ''[scrubbed_]genus__@DwC__@vegpath.org'')::util.col);
|
|
| 1111 |
-- DROP __ CASCADE doesn''t work when there are dependent views |
|
| 1032 | 1112 |
'; |
| 1033 | 1113 |
|
| 1034 | 1114 |
|
| ... | ... | |
| 1055 | 1135 |
# rename column |
| 1056 | 1136 |
# rename CHECK constraint |
| 1057 | 1137 |
SELECT util.derived_cols_update(''"TNRS".taxon_match''::regclass);
|
| 1138 |
|
|
| 1139 |
to drop: |
|
| 1140 |
SELECT util.drop_derived_col((''"TNRS".taxon_match'', ''[scrubbed_]specificEpithet__@DwC__@vegpath.org'')::util.col);
|
|
| 1141 |
-- DROP __ CASCADE doesn''t work when there are dependent views |
|
| 1058 | 1142 |
'; |
| 1059 | 1143 |
|
| 1060 | 1144 |
|
| ... | ... | |
| 1081 | 1165 |
# rename column |
| 1082 | 1166 |
# rename CHECK constraint |
| 1083 | 1167 |
SELECT util.derived_cols_update(''"TNRS".taxon_match''::regclass);
|
| 1168 |
|
|
| 1169 |
to drop: |
|
| 1170 |
SELECT util.drop_derived_col((''"TNRS".taxon_match'', ''[scrubbed_]species[_binom]~(-Accepted_-)__@TNRS__@vegpath.org'')::util.col);
|
|
| 1171 |
-- DROP __ CASCADE doesn''t work when there are dependent views |
|
| 1084 | 1172 |
'; |
| 1085 | 1173 |
|
| 1086 | 1174 |
|
| ... | ... | |
| 1109 | 1197 |
# rename column |
| 1110 | 1198 |
# rename CHECK constraint |
| 1111 | 1199 |
SELECT util.derived_cols_update(''"TNRS".taxon_match''::regclass);
|
| 1200 |
|
|
| 1201 |
to drop: |
|
| 1202 |
SELECT util.drop_derived_col((''"TNRS".taxon_match'', ''[scrubbed_]morphospecies[_binomial]__@Brad__.TNRS@vegpath.org'')::util.col);
|
|
| 1203 |
-- DROP __ CASCADE doesn''t work when there are dependent views |
|
| 1112 | 1204 |
'; |
| 1113 | 1205 |
|
| 1114 | 1206 |
|
| ... | ... | |
| 1135 | 1227 |
# rename column |
| 1136 | 1228 |
# rename CHECK constraint |
| 1137 | 1229 |
SELECT util.derived_cols_update(''"TNRS".taxon_match''::regclass);
|
| 1230 |
|
|
| 1231 |
to drop: |
|
| 1232 |
SELECT util.drop_derived_col((''"TNRS".taxon_match'', ''[scrubbed_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org'')::util.col);
|
|
| 1233 |
-- DROP __ CASCADE doesn''t work when there are dependent views |
|
| 1138 | 1234 |
'; |
| 1139 | 1235 |
|
| 1140 | 1236 |
|
| ... | ... | |
| 1161 | 1257 |
# rename column |
| 1162 | 1258 |
# rename CHECK constraint |
| 1163 | 1259 |
SELECT util.derived_cols_update(''"TNRS".taxon_match''::regclass);
|
| 1260 |
|
|
| 1261 |
to drop: |
|
| 1262 |
SELECT util.drop_derived_col((''"TNRS".taxon_match'', ''[scrubbed_]infraspecificEpithet__@DwC__@vegpath.org'')::util.col);
|
|
| 1263 |
-- DROP __ CASCADE doesn''t work when there are dependent views |
|
| 1164 | 1264 |
'; |
| 1165 | 1265 |
|
| 1166 | 1266 |
|
| ... | ... | |
| 1187 | 1287 |
# rename column |
| 1188 | 1288 |
# rename CHECK constraint |
| 1189 | 1289 |
SELECT util.derived_cols_update(''"TNRS".taxon_match''::regclass);
|
| 1290 |
|
|
| 1291 |
to drop: |
|
| 1292 |
SELECT util.drop_derived_col((''"TNRS".taxon_match'', ''[scrubbed_]name[_no_author]~(-Accepted_-)__@TNRS__@vegpath.org'')::util.col);
|
|
| 1293 |
-- DROP __ CASCADE doesn''t work when there are dependent views |
|
| 1190 | 1294 |
'; |
| 1191 | 1295 |
|
| 1192 | 1296 |
|
| ... | ... | |
| 1213 | 1317 |
# rename column |
| 1214 | 1318 |
# rename CHECK constraint |
| 1215 | 1319 |
SELECT util.derived_cols_update(''"TNRS".taxon_match''::regclass);
|
| 1320 |
|
|
| 1321 |
to drop: |
|
| 1322 |
SELECT util.drop_derived_col((''"TNRS".taxon_match'', ''[scrubbed_]author~(-Accepted_-)__@TNRS__@vegpath.org'')::util.col);
|
|
| 1323 |
-- DROP __ CASCADE doesn''t work when there are dependent views |
|
| 1216 | 1324 |
'; |
| 1217 | 1325 |
|
| 1218 | 1326 |
|
| ... | ... | |
| 1239 | 1347 |
# rename column |
| 1240 | 1348 |
# rename CHECK constraint |
| 1241 | 1349 |
SELECT util.derived_cols_update(''"TNRS".taxon_match''::regclass);
|
| 1350 |
|
|
| 1351 |
to drop: |
|
| 1352 |
SELECT util.drop_derived_col((''"TNRS".taxon_match'', ''[scrubbed_]scientificName[_with_author]__@DwC__@vegpath.org'')::util.col);
|
|
| 1353 |
-- DROP __ CASCADE doesn''t work when there are dependent views |
|
| 1242 | 1354 |
'; |
| 1243 | 1355 |
|
| 1244 | 1356 |
|
| trunk/schemas/util.sql | ||
|---|---|---|
| 2009 | 2009 |
# rename column |
| 2010 | 2010 |
# rename CHECK constraint |
| 2011 | 2011 |
SELECT util.derived_cols_update('||util.quote_typed((def_).col.table_)||');
|
| 2012 |
|
|
| 2013 |
to drop: |
|
| 2014 |
SELECT util.drop_derived_col('||util.quote_typed((def_).col)||');
|
|
| 2015 |
-- DROP __ CASCADE doesn''t work when there are dependent views |
|
| 2012 | 2016 |
') |
| 2013 | 2017 |
-- **IMPORTANT**: vars can't have same name as params, which will be substituted |
| 2014 | 2018 |
FROM (SELECT util.derived_col_def(def.col)/*expr from DB*/ AS def_) s |
| trunk/schemas/vegbien.sql | ||
|---|---|---|
| 20276 | 20276 |
# rename column |
| 20277 | 20277 |
# rename CHECK constraint |
| 20278 | 20278 |
SELECT util.derived_cols_update(''"TNRS".taxon_match''::regclass);
|
| 20279 |
|
|
| 20280 |
to drop: |
|
| 20281 |
SELECT util.drop_derived_col((''"TNRS".taxon_match'', ''[parsed_]morphospecies[_suffix]__@Brad__.morphosp@vegpath.org'')::util.col);
|
|
| 20282 |
-- DROP __ CASCADE doesn''t work when there are dependent views |
|
| 20279 | 20283 |
'; |
| 20280 | 20284 |
|
| 20281 | 20285 |
|
| ... | ... | |
| 20296 | 20300 |
# rename column |
| 20297 | 20301 |
# rename CHECK constraint |
| 20298 | 20302 |
SELECT util.derived_cols_update(''"TNRS".taxon_match''::regclass);
|
| 20303 |
|
|
| 20304 |
to drop: |
|
| 20305 |
SELECT util.drop_derived_col((''"TNRS".taxon_match'', ''[matched_]species[_binomial]~(-Accepted_-)__@TNRS__@vegpath.org'')::util.col);
|
|
| 20306 |
-- DROP __ CASCADE doesn''t work when there are dependent views |
|
| 20299 | 20307 |
'; |
| 20300 | 20308 |
|
| 20301 | 20309 |
|
| ... | ... | |
| 20316 | 20324 |
# rename column |
| 20317 | 20325 |
# rename CHECK constraint |
| 20318 | 20326 |
SELECT util.derived_cols_update(''"TNRS".taxon_match''::regclass);
|
| 20327 |
|
|
| 20328 |
to drop: |
|
| 20329 |
SELECT util.drop_derived_col((''"TNRS".taxon_match'', ''matched~Name[_no_author]___@TNRS__@vegpath.org'')::util.col);
|
|
| 20330 |
-- DROP __ CASCADE doesn''t work when there are dependent views |
|
| 20319 | 20331 |
'; |
| 20320 | 20332 |
|
| 20321 | 20333 |
|
| ... | ... | |
| 20336 | 20348 |
# rename column |
| 20337 | 20349 |
# rename CHECK constraint |
| 20338 | 20350 |
SELECT util.derived_cols_update(''"TNRS".taxon_match''::regclass);
|
| 20351 |
|
|
| 20352 |
to drop: |
|
| 20353 |
SELECT util.drop_derived_col((''"TNRS".taxon_match'', ''[matched_]scientificName[_with_author]__@DwC__@vegpath.org'')::util.col);
|
|
| 20354 |
-- DROP __ CASCADE doesn''t work when there are dependent views |
|
| 20339 | 20355 |
'; |
| 20340 | 20356 |
|
| 20341 | 20357 |
|
| ... | ... | |
| 20356 | 20372 |
# rename column |
| 20357 | 20373 |
# rename CHECK constraint |
| 20358 | 20374 |
SELECT util.derived_cols_update(''"TNRS".taxon_match''::regclass);
|
| 20375 |
|
|
| 20376 |
to drop: |
|
| 20377 |
SELECT util.drop_derived_col((''"TNRS".taxon_match'', ''matched_has_accepted'')::util.col);
|
|
| 20378 |
-- DROP __ CASCADE doesn''t work when there are dependent views |
|
| 20359 | 20379 |
'; |
| 20360 | 20380 |
|
| 20361 | 20381 |
|
| ... | ... | |
| 20384 | 20404 |
# rename column |
| 20385 | 20405 |
# rename CHECK constraint |
| 20386 | 20406 |
SELECT util.derived_cols_update(''"TNRS".taxon_match''::regclass);
|
| 20407 |
|
|
| 20408 |
to drop: |
|
| 20409 |
SELECT util.drop_derived_col((''"TNRS".taxon_match'', ''Accepted_family__@TNRS__@vegpath.org'')::util.col);
|
|
| 20410 |
-- DROP __ CASCADE doesn''t work when there are dependent views |
|
| 20387 | 20411 |
'; |
| 20388 | 20412 |
|
| 20389 | 20413 |
|
| ... | ... | |
| 20404 | 20428 |
# rename column |
| 20405 | 20429 |
# rename CHECK constraint |
| 20406 | 20430 |
SELECT util.derived_cols_update(''"TNRS".taxon_match''::regclass);
|
| 20431 |
|
|
| 20432 |
to drop: |
|
| 20433 |
SELECT util.drop_derived_col((''"TNRS".taxon_match'', ''Accepted_species[_binomial]__@TNRS__@vegpath.org'')::util.col);
|
|
| 20434 |
-- DROP __ CASCADE doesn''t work when there are dependent views |
|
| 20407 | 20435 |
'; |
| 20408 | 20436 |
|
| 20409 | 20437 |
|
| ... | ... | |
| 20424 | 20452 |
# rename column |
| 20425 | 20453 |
# rename CHECK constraint |
| 20426 | 20454 |
SELECT util.derived_cols_update(''"TNRS".taxon_match''::regclass);
|
| 20455 |
|
|
| 20456 |
to drop: |
|
| 20457 |
SELECT util.drop_derived_col((''"TNRS".taxon_match'', ''__accepted_{genus,specific_epithet,infra_{rank,epithet}}'')::util.col);
|
|
| 20458 |
-- DROP __ CASCADE doesn''t work when there are dependent views |
|
| 20427 | 20459 |
'; |
| 20428 | 20460 |
|
| 20429 | 20461 |
|
| ... | ... | |
| 20444 | 20476 |
# rename column |
| 20445 | 20477 |
# rename CHECK constraint |
| 20446 | 20478 |
SELECT util.derived_cols_update(''"TNRS".taxon_match''::regclass);
|
| 20479 |
|
|
| 20480 |
to drop: |
|
| 20481 |
SELECT util.drop_derived_col((''"TNRS".taxon_match'', ''[accepted_]genus__@DwC__@vegpath.org'')::util.col);
|
|
| 20482 |
-- DROP __ CASCADE doesn''t work when there are dependent views |
|
| 20447 | 20483 |
'; |
| 20448 | 20484 |
|
| 20449 | 20485 |
|
| ... | ... | |
| 20464 | 20500 |
# rename column |
| 20465 | 20501 |
# rename CHECK constraint |
| 20466 | 20502 |
SELECT util.derived_cols_update(''"TNRS".taxon_match''::regclass);
|
| 20503 |
|
|
| 20504 |
to drop: |
|
| 20505 |
SELECT util.drop_derived_col((''"TNRS".taxon_match'', ''[accepted_]specificEpithet__@DwC__@vegpath.org'')::util.col);
|
|
| 20506 |
-- DROP __ CASCADE doesn''t work when there are dependent views |
|
| 20467 | 20507 |
'; |
| 20468 | 20508 |
|
| 20469 | 20509 |
|
| ... | ... | |
| 20492 | 20532 |
# rename column |
| 20493 | 20533 |
# rename CHECK constraint |
| 20494 | 20534 |
SELECT util.derived_cols_update(''"TNRS".taxon_match''::regclass);
|
| 20535 |
|
|
| 20536 |
to drop: |
|
| 20537 |
SELECT util.drop_derived_col((''"TNRS".taxon_match'', ''[accepted_]morphospecies[_binomial]__@Brad__.TNRS@vegpath.org'')::util.col);
|
|
| 20538 |
-- DROP __ CASCADE doesn''t work when there are dependent views |
|
| 20495 | 20539 |
'; |
| 20496 | 20540 |
|
| 20497 | 20541 |
|
| ... | ... | |
| 20512 | 20556 |
# rename column |
| 20513 | 20557 |
# rename CHECK constraint |
| 20514 | 20558 |
SELECT util.derived_cols_update(''"TNRS".taxon_match''::regclass);
|
| 20559 |
|
|
| 20560 |
to drop: |
|
| 20561 |
SELECT util.drop_derived_col((''"TNRS".taxon_match'', ''__accepted_infraspecific_label'')::util.col);
|
|
| 20562 |
-- DROP __ CASCADE doesn''t work when there are dependent views |
|
| 20515 | 20563 |
'; |
| 20516 | 20564 |
|
| 20517 | 20565 |
|
| ... | ... | |
| 20532 | 20580 |
# rename column |
| 20533 | 20581 |
# rename CHECK constraint |
| 20534 | 20582 |
SELECT util.derived_cols_update(''"TNRS".taxon_match''::regclass);
|
| 20583 |
|
|
| 20584 |
to drop: |
|
| 20585 |
SELECT util.drop_derived_col((''"TNRS".taxon_match'', ''__accepted_infraspecific_{rank,epithet}'')::util.col);
|
|
| 20586 |
-- DROP __ CASCADE doesn''t work when there are dependent views |
|
| 20535 | 20587 |
'; |
| 20536 | 20588 |
|
| 20537 | 20589 |
|
| ... | ... | |
| 20552 | 20604 |
# rename column |
| 20553 | 20605 |
# rename CHECK constraint |
| 20554 | 20606 |
SELECT util.derived_cols_update(''"TNRS".taxon_match''::regclass);
|
| 20607 |
|
|
| 20608 |
to drop: |
|
| 20609 |
SELECT util.drop_derived_col((''"TNRS".taxon_match'', ''[accepted_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org'')::util.col);
|
|
| 20610 |
-- DROP __ CASCADE doesn''t work when there are dependent views |
|
| 20555 | 20611 |
'; |
| 20556 | 20612 |
|
| 20557 | 20613 |
|
| ... | ... | |
| 20572 | 20628 |
# rename column |
| 20573 | 20629 |
# rename CHECK constraint |
| 20574 | 20630 |
SELECT util.derived_cols_update(''"TNRS".taxon_match''::regclass);
|
| 20631 |
|
|
| 20632 |
to drop: |
|
| 20633 |
SELECT util.drop_derived_col((''"TNRS".taxon_match'', ''[accepted_]infraspecificEpithet__@DwC__@vegpath.org'')::util.col);
|
|
| 20634 |
-- DROP __ CASCADE doesn''t work when there are dependent views |
|
| 20575 | 20635 |
'; |
| 20576 | 20636 |
|
| 20577 | 20637 |
|
| ... | ... | |
| 20592 | 20652 |
# rename column |
| 20593 | 20653 |
# rename CHECK constraint |
| 20594 | 20654 |
SELECT util.derived_cols_update(''"TNRS".taxon_match''::regclass);
|
| 20655 |
|
|
| 20656 |
to drop: |
|
| 20657 |
SELECT util.drop_derived_col((''"TNRS".taxon_match'', ''[accepted_]scientificName[_with_author]__@DwC__@vegpath.org'')::util.col);
|
|
| 20658 |
-- DROP __ CASCADE doesn''t work when there are dependent views |
|
| 20595 | 20659 |
'; |
| 20596 | 20660 |
|
| 20597 | 20661 |
|
| ... | ... | |
| 20612 | 20676 |
# rename column |
| 20613 | 20677 |
# rename CHECK constraint |
| 20614 | 20678 |
SELECT util.derived_cols_update(''"TNRS".taxon_match''::regclass);
|
| 20679 |
|
|
| 20680 |
to drop: |
|
| 20681 |
SELECT util.drop_derived_col((''"TNRS".taxon_match'', ''[scrubbed_]taxonomicStatus__@DwC__@vegpath.org'')::util.col);
|
|
| 20682 |
-- DROP __ CASCADE doesn''t work when there are dependent views |
|
| 20615 | 20683 |
'; |
| 20616 | 20684 |
|
| 20617 | 20685 |
|
| ... | ... | |
| 20638 | 20706 |
# rename column |
| 20639 | 20707 |
# rename CHECK constraint |
| 20640 | 20708 |
SELECT util.derived_cols_update(''"TNRS".taxon_match''::regclass);
|
| 20709 |
|
|
| 20710 |
to drop: |
|
| 20711 |
SELECT util.drop_derived_col((''"TNRS".taxon_match'', ''[scrubbed_]taxonRank__@DwC__@vegpath.org'')::util.col);
|
|
| 20712 |
-- DROP __ CASCADE doesn''t work when there are dependent views |
|
| 20641 | 20713 |
'; |
| 20642 | 20714 |
|
| 20643 | 20715 |
|
| ... | ... | |
| 20664 | 20736 |
# rename column |
| 20665 | 20737 |
# rename CHECK constraint |
| 20666 | 20738 |
SELECT util.derived_cols_update(''"TNRS".taxon_match''::regclass);
|
| 20739 |
|
|
| 20740 |
to drop: |
|
| 20741 |
SELECT util.drop_derived_col((''"TNRS".taxon_match'', ''[scrubbed_]family~(-Accepted_-)__@TNRS__@vegpath.org'')::util.col);
|
|
| 20742 |
-- DROP __ CASCADE doesn''t work when there are dependent views |
|
| 20667 | 20743 |
'; |
| 20668 | 20744 |
|
| 20669 | 20745 |
|
| ... | ... | |
| 20690 | 20766 |
# rename column |
| 20691 | 20767 |
# rename CHECK constraint |
| 20692 | 20768 |
SELECT util.derived_cols_update(''"TNRS".taxon_match''::regclass);
|
| 20769 |
|
|
| 20770 |
to drop: |
|
| 20771 |
SELECT util.drop_derived_col((''"TNRS".taxon_match'', ''[scrubbed_]genus__@DwC__@vegpath.org'')::util.col);
|
|
| 20772 |
-- DROP __ CASCADE doesn''t work when there are dependent views |
|
| 20693 | 20773 |
'; |
| 20694 | 20774 |
|
| 20695 | 20775 |
|
| ... | ... | |
| 20716 | 20796 |
# rename column |
| 20717 | 20797 |
# rename CHECK constraint |
| 20718 | 20798 |
SELECT util.derived_cols_update(''"TNRS".taxon_match''::regclass);
|
| 20799 |
|
|
| 20800 |
to drop: |
|
| 20801 |
SELECT util.drop_derived_col((''"TNRS".taxon_match'', ''[scrubbed_]specificEpithet__@DwC__@vegpath.org'')::util.col);
|
|
| 20802 |
-- DROP __ CASCADE doesn''t work when there are dependent views |
|
| 20719 | 20803 |
'; |
| 20720 | 20804 |
|
| 20721 | 20805 |
|
| ... | ... | |
| 20742 | 20826 |
# rename column |
| 20743 | 20827 |
# rename CHECK constraint |
| 20744 | 20828 |
SELECT util.derived_cols_update(''"TNRS".taxon_match''::regclass);
|
| 20829 |
|
|
| 20830 |
to drop: |
|
| 20831 |
SELECT util.drop_derived_col((''"TNRS".taxon_match'', ''[scrubbed_]species[_binom]~(-Accepted_-)__@TNRS__@vegpath.org'')::util.col);
|
|
| 20832 |
-- DROP __ CASCADE doesn''t work when there are dependent views |
|
| 20745 | 20833 |
'; |
| 20746 | 20834 |
|
| 20747 | 20835 |
|
| ... | ... | |
| 20770 | 20858 |
# rename column |
| 20771 | 20859 |
# rename CHECK constraint |
| 20772 | 20860 |
SELECT util.derived_cols_update(''"TNRS".taxon_match''::regclass);
|
| 20861 |
|
|
| 20862 |
to drop: |
|
| 20863 |
SELECT util.drop_derived_col((''"TNRS".taxon_match'', ''[scrubbed_]morphospecies[_binomial]__@Brad__.TNRS@vegpath.org'')::util.col);
|
|
| 20864 |
-- DROP __ CASCADE doesn''t work when there are dependent views |
|
| 20773 | 20865 |
'; |
| 20774 | 20866 |
|
| 20775 | 20867 |
|
| ... | ... | |
| 20796 | 20888 |
# rename column |
| 20797 | 20889 |
# rename CHECK constraint |
| 20798 | 20890 |
SELECT util.derived_cols_update(''"TNRS".taxon_match''::regclass);
|
| 20891 |
|
|
| 20892 |
to drop: |
|
| 20893 |
SELECT util.drop_derived_col((''"TNRS".taxon_match'', ''[scrubbed_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org'')::util.col);
|
|
| 20894 |
-- DROP __ CASCADE doesn''t work when there are dependent views |
|
| 20799 | 20895 |
'; |
| 20800 | 20896 |
|
| 20801 | 20897 |
|
| ... | ... | |
| 20822 | 20918 |
# rename column |
| 20823 | 20919 |
# rename CHECK constraint |
| 20824 | 20920 |
SELECT util.derived_cols_update(''"TNRS".taxon_match''::regclass);
|
| 20921 |
|
|
| 20922 |
to drop: |
|
| 20923 |
SELECT util.drop_derived_col((''"TNRS".taxon_match'', ''[scrubbed_]infraspecificEpithet__@DwC__@vegpath.org'')::util.col);
|
|
| 20924 |
-- DROP __ CASCADE doesn''t work when there are dependent views |
|
| 20825 | 20925 |
'; |
| 20826 | 20926 |
|
| 20827 | 20927 |
|
| ... | ... | |
| 20848 | 20948 |
# rename column |
| 20849 | 20949 |
# rename CHECK constraint |
| 20850 | 20950 |
SELECT util.derived_cols_update(''"TNRS".taxon_match''::regclass);
|
| 20951 |
|
|
| 20952 |
to drop: |
|
| 20953 |
SELECT util.drop_derived_col((''"TNRS".taxon_match'', ''[scrubbed_]name[_no_author]~(-Accepted_-)__@TNRS__@vegpath.org'')::util.col);
|
|
| 20954 |
-- DROP __ CASCADE doesn''t work when there are dependent views |
|
| 20851 | 20955 |
'; |
| 20852 | 20956 |
|
| 20853 | 20957 |
|
| ... | ... | |
| 20874 | 20978 |
# rename column |
| 20875 | 20979 |
# rename CHECK constraint |
| 20876 | 20980 |
SELECT util.derived_cols_update(''"TNRS".taxon_match''::regclass);
|
| 20981 |
|
|
| 20982 |
to drop: |
|
| 20983 |
SELECT util.drop_derived_col((''"TNRS".taxon_match'', ''[scrubbed_]author~(-Accepted_-)__@TNRS__@vegpath.org'')::util.col);
|
|
| 20984 |
-- DROP __ CASCADE doesn''t work when there are dependent views |
|
| 20877 | 20985 |
'; |
| 20878 | 20986 |
|
| 20879 | 20987 |
|
| ... | ... | |
| 20900 | 21008 |
# rename column |
| 20901 | 21009 |
# rename CHECK constraint |
| 20902 | 21010 |
SELECT util.derived_cols_update(''"TNRS".taxon_match''::regclass);
|
| 21011 |
|
|
| 21012 |
to drop: |
|
| 21013 |
SELECT util.drop_derived_col((''"TNRS".taxon_match'', ''[scrubbed_]scientificName[_with_author]__@DwC__@vegpath.org'')::util.col);
|
|
| 21014 |
-- DROP __ CASCADE doesn''t work when there are dependent views |
|
| 20903 | 21015 |
'; |
| 20904 | 21016 |
|
| 20905 | 21017 |
|
Also available in: Unified diff
fix: schemas/util.sql: derived_col_update(): also need steps to drop column, because DROP __ CASCADE doesn't work when there are dependent views