Revision 11614
Added by Aaron Marcuse-Kubitza about 11 years ago
| inputs/.TNRS/schema.sql | ||
|---|---|---|
| 15 | 15 |
--CREATE SCHEMA "TNRS"; |
| 16 | 16 |
|
| 17 | 17 |
|
| 18 |
-- |
|
| 19 |
-- Name: SCHEMA "TNRS"; Type: COMMENT; Schema: -; Owner: - |
|
| 20 |
-- |
|
| 21 |
|
|
| 22 |
COMMENT ON SCHEMA "TNRS" IS 'IMPORTANT: when changing this schema, you must also make the same changes on vegbiendev: |
|
| 23 |
back up existing TNRS schema: |
|
| 24 |
$ make backups/TNRS.backup-remake # runtime: 3 min ("real 2m44.277s")
|
|
| 25 |
make changes: |
|
| 26 |
e.g. to set column types: |
|
| 27 |
SELECT util.set_col_types(''"TNRS".tnrs'', ARRAY[
|
|
| 28 |
(''col'', ''new_type'')
|
|
| 29 |
]::util.col_cast[]); -- runtime: 9 min ("531282 ms")';
|
|
| 30 |
|
|
| 31 |
|
|
| 18 | 32 |
SET search_path = "TNRS", pg_catalog; |
| 19 | 33 |
|
| 20 | 34 |
-- |
| ... | ... | |
| 193 | 207 |
-- |
| 194 | 208 |
|
| 195 | 209 |
COMMENT ON TABLE tnrs IS 'IMPORTANT: when changing this table''s schema, you may need to re-run TNRS: |
| 196 |
$ inputs/.TNRS/data.sql.run refresh |
|
| 197 |
you must also make the same changes on vegbiendev: e.g. |
|
| 198 |
$ make backups/TNRS.backup-remake # runtime: 3 min ("real 2m44.277s")
|
|
| 199 |
SELECT util.set_col_types(''"TNRS".tnrs'', ARRAY[
|
|
| 200 |
(''col'', ''new_type'')
|
|
| 201 |
]::util.col_cast[]); |
|
| 202 |
runtime: 9 min ("531282 ms")';
|
|
| 210 |
$ inputs/.TNRS/data.sql.run refresh'; |
|
| 203 | 211 |
|
| 204 | 212 |
|
| 205 | 213 |
-- |
Also available in: Unified diff
inputs/.TNRS/schema.sql: tnrs: moved instructions to apply schema changes on vegbiendev to the TNRS schema, because this applies to all elements in the TNRS schema, not just the tnrs table