Revision 14860
Added by Aaron Marcuse-Kubitza about 10 years ago
| trunk/inputs/Cyrille_traits/trait_observation/postprocess.sql | ||
|---|---|---|
| 3 | 3 |
SELECT create_if_not_exists( |
| 4 | 4 |
$$CREATE INDEX $$||(:table_str||%'__accessRights')||$$ |
| 5 | 5 |
ON $$||:table_str||$$ ("accessRights")$$)
|
| 6 |
; -- runtime: 4 s ("3596.509 ms") @frenzy
|
|
| 6 |
; -- runtime: 4 s ("3596.509 ms") @frenzy, 3 s ("2533.529 ms") @vegbiendev
|
|
| 7 | 7 |
|
| 8 | 8 |
-- remove private data |
| 9 | 9 |
DELETE FROM :table WHERE "accessRights" = 'private' |
Also available in: Unified diff
inputs/Cyrille_traits/trait_observation/postprocess.sql: accessRights index: added vegbiendev runtime