Revision 14797
Added by Aaron Marcuse-Kubitza about 10 years ago
| trunk/schemas/public_.sql | ||
|---|---|---|
| 2192 | 2192 |
PERFORM util.rematerialize_view('geoscrub_input', 'geoscrub_input_view', $$
|
| 2193 | 2193 |
GRANT SELECT ON TABLE geoscrub_input TO bien_read; |
| 2194 | 2194 |
GRANT SELECT ON TABLE geoscrub_input_view TO bien_read; |
| 2195 |
|
|
| 2196 |
CREATE UNIQUE INDEX ON geoscrub_input ((ARRAY["decimalLatitude"]), (ARRAY["decimalLongitude"]), (ARRAY[country]), (ARRAY["stateProvince"]), (ARRAY[county])); |
|
| 2195 | 2197 |
$$, repopulate); |
| 2196 | 2198 |
END; |
| 2197 | 2199 |
$_$; |
| trunk/schemas/vegbien.sql | ||
|---|---|---|
| 2192 | 2192 |
PERFORM util.rematerialize_view('geoscrub_input', 'geoscrub_input_view', $$
|
| 2193 | 2193 |
GRANT SELECT ON TABLE geoscrub_input TO bien_read; |
| 2194 | 2194 |
GRANT SELECT ON TABLE geoscrub_input_view TO bien_read; |
| 2195 |
|
|
| 2196 |
CREATE UNIQUE INDEX ON geoscrub_input ((ARRAY["decimalLatitude"]), (ARRAY["decimalLongitude"]), (ARRAY[country]), (ARRAY["stateProvince"]), (ARRAY[county])); |
|
| 2195 | 2197 |
$$, repopulate); |
| 2196 | 2198 |
END; |
| 2197 | 2199 |
$_$; |
Also available in: Unified diff
schemas/public_.sql: geoscrub_input_view_modify(): add unique constraint on the same columns as geoscrub.geoscrub_output, as a sanity check to assist future debugging