Revision 5705
Added by Aaron Marcuse-Kubitza over 12 years ago
| vegbien.my.sql | ||
|---|---|---|
| 201 | 201 |
|
| 202 | 202 |
|
| 203 | 203 |
-- |
| 204 |
-- Name: taxonlabel_2_set_canon_label_id(); Type: FUNCTION; Schema: public; Owner: - |
|
| 204 |
-- Name: taxonlabel_2_set_canon_label_id_on_insert(); Type: FUNCTION; Schema: public; Owner: -
|
|
| 205 | 205 |
-- |
| 206 | 206 |
|
| 207 | 207 |
|
| 208 | 208 |
|
| 209 | 209 |
|
| 210 | 210 |
-- |
| 211 |
-- Name: taxonlabel_2_set_canon_label_id_on_update(); Type: FUNCTION; Schema: public; Owner: - |
|
| 212 |
-- |
|
| 213 |
|
|
| 214 |
|
|
| 215 |
|
|
| 216 |
|
|
| 217 |
-- |
|
| 211 | 218 |
-- Name: taxonlabel_3_parent_id_avoid_self_ref(); Type: FUNCTION; Schema: public; Owner: - |
| 212 | 219 |
-- |
| 213 | 220 |
|
| ... | ... | |
| 4232 | 4239 |
|
| 4233 | 4240 |
|
| 4234 | 4241 |
-- |
| 4235 |
-- Name: taxonlabel_2_set_canon_label_id; Type: TRIGGER; Schema: public; Owner: - |
|
| 4242 |
-- Name: taxonlabel_2_set_canon_label_id_on_insert; Type: TRIGGER; Schema: public; Owner: -
|
|
| 4236 | 4243 |
-- |
| 4237 | 4244 |
|
| 4238 | 4245 |
|
| 4239 | 4246 |
|
| 4240 | 4247 |
|
| 4241 | 4248 |
-- |
| 4249 |
-- Name: taxonlabel_2_set_canon_label_id_on_update; Type: TRIGGER; Schema: public; Owner: - |
|
| 4250 |
-- |
|
| 4251 |
|
|
| 4252 |
|
|
| 4253 |
|
|
| 4254 |
|
|
| 4255 |
-- |
|
| 4242 | 4256 |
-- Name: taxonlabel_3_parent_id_avoid_self_ref; Type: TRIGGER; Schema: public; Owner: - |
| 4243 | 4257 |
-- |
| 4244 | 4258 |
|
Also available in: Unified diff
schemas/vegbien.sql: taxonlabel: taxonlabel_2_set_canon_label_id(): Only run if matched_label_id has actually changed, to avoid infinite recursion when updating canon_label_id on labels that resolve to this label when there are cycles in the data