Revision 14364
Added by Aaron Marcuse-Kubitza over 10 years ago
| trunk/inputs/.TNRS/schema.sql | ||
|---|---|---|
| 575 | 575 |
to port derived column changes to vegbiendev: |
| 576 | 576 |
SELECT util.derived_cols_export(''"TNRS".taxon_match'');
|
| 577 | 577 |
# run the returned SQL on vegbiendev |
| 578 |
-- runtime: 30 min ("5564201 rows affected, 1624829 ms execution time")
|
|
| 578 | 579 |
SELECT util.recreate_view(''"TNRS".taxon_best_match'');
|
| 579 | 580 |
|
| 580 |
to remove columns or add columns at the end: |
|
| 581 |
to add a new derived column: |
|
| 582 |
SELECT util.derived_col_update(((''"TNRS".taxon_match'', ''col''), $$
|
|
| 583 |
expr |
|
| 584 |
$$)); |
|
| 585 |
SELECT util.derived_cols_populate(''"TNRS".taxon_match'');
|
|
| 581 | 586 |
SELECT util.recreate_view(''"TNRS".taxon_best_match'');
|
| 582 | 587 |
$ make schemas/remake |
| 583 | 588 |
|
| ... | ... | |
| 589 | 594 |
SELECT util.recreate_view(''"TNRS".taxon_best_match'');
|
| 590 | 595 |
$ make schemas/remake |
| 591 | 596 |
|
| 592 |
to add a new derived column: |
|
| 593 |
SELECT util.derived_col_update(((''"TNRS".taxon_match'', ''col''), $$
|
|
| 594 |
expr |
|
| 595 |
$$)); |
|
| 596 |
SELECT util.derived_cols_populate(''"TNRS".taxon_match'');
|
|
| 597 |
-- runtime: 30 min ("5564201 rows affected, 1624829 ms execution time")
|
|
| 598 |
|
|
| 599 | 597 |
to add a constraint: runtime: 3 min ("173620 ms")
|
| 600 | 598 |
'; |
| 601 | 599 |
|
| trunk/schemas/vegbien.sql | ||
|---|---|---|
| 20236 | 20236 |
to port derived column changes to vegbiendev: |
| 20237 | 20237 |
SELECT util.derived_cols_export(''"TNRS".taxon_match'');
|
| 20238 | 20238 |
# run the returned SQL on vegbiendev |
| 20239 |
-- runtime: 30 min ("5564201 rows affected, 1624829 ms execution time")
|
|
| 20239 | 20240 |
SELECT util.recreate_view(''"TNRS".taxon_best_match'');
|
| 20240 | 20241 |
|
| 20241 |
to remove columns or add columns at the end: |
|
| 20242 |
to add a new derived column: |
|
| 20243 |
SELECT util.derived_col_update(((''"TNRS".taxon_match'', ''col''), $$
|
|
| 20244 |
expr |
|
| 20245 |
$$)); |
|
| 20246 |
SELECT util.derived_cols_populate(''"TNRS".taxon_match'');
|
|
| 20242 | 20247 |
SELECT util.recreate_view(''"TNRS".taxon_best_match'');
|
| 20243 | 20248 |
$ make schemas/remake |
| 20244 | 20249 |
|
| ... | ... | |
| 20250 | 20255 |
SELECT util.recreate_view(''"TNRS".taxon_best_match'');
|
| 20251 | 20256 |
$ make schemas/remake |
| 20252 | 20257 |
|
| 20253 |
to add a new derived column: |
|
| 20254 |
SELECT util.derived_col_update(((''"TNRS".taxon_match'', ''col''), $$
|
|
| 20255 |
expr |
|
| 20256 |
$$)); |
|
| 20257 |
SELECT util.derived_cols_populate(''"TNRS".taxon_match'');
|
|
| 20258 |
-- runtime: 30 min ("5564201 rows affected, 1624829 ms execution time")
|
|
| 20259 |
|
|
| 20260 | 20258 |
to add a constraint: runtime: 3 min ("173620 ms")
|
| 20261 | 20259 |
'; |
| 20262 | 20260 |
|
Also available in: Unified diff
inputs/.TNRS/schema.sql: taxon_match: to remove columns or add columns at the end: merged into "to add a new derived column"