Revision 5654
Added by Aaron Marcuse-Kubitza about 12 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 194 | 194 |
|
| 195 | 195 |
|
| 196 | 196 |
-- |
| 197 |
-- Name: taxonlabel_2_propagate_canon_label_id(); Type: FUNCTION; Schema: public; Owner: -
|
|
| 197 |
-- Name: taxonlabel_2_set_canon_label_id(); Type: FUNCTION; Schema: public; Owner: -
|
|
| 198 | 198 |
-- |
| 199 | 199 |
|
| 200 | 200 |
|
| ... | ... | |
| 4156 | 4156 |
|
| 4157 | 4157 |
|
| 4158 | 4158 |
-- |
| 4159 |
-- Name: taxonlabel_2_propagate_canon_label_id; Type: TRIGGER; Schema: public; Owner: -
|
|
| 4159 |
-- Name: taxonlabel_2_set_canon_label_id; Type: TRIGGER; Schema: public; Owner: -
|
|
| 4160 | 4160 |
-- |
| 4161 | 4161 |
|
| 4162 | 4162 |
|
| schemas/vegbien.sql | ||
|---|---|---|
| 481 | 481 |
|
| 482 | 482 |
|
| 483 | 483 |
-- |
| 484 |
-- Name: taxonlabel_2_propagate_canon_label_id(); Type: FUNCTION; Schema: public; Owner: -
|
|
| 484 |
-- Name: taxonlabel_2_set_canon_label_id(); Type: FUNCTION; Schema: public; Owner: -
|
|
| 485 | 485 |
-- |
| 486 | 486 |
|
| 487 |
CREATE FUNCTION taxonlabel_2_propagate_canon_label_id() RETURNS trigger
|
|
| 487 |
CREATE FUNCTION taxonlabel_2_set_canon_label_id() RETURNS trigger
|
|
| 488 | 488 |
LANGUAGE plpgsql |
| 489 | 489 |
AS $$ |
| 490 | 490 |
BEGIN |
| ... | ... | |
| 4909 | 4909 |
|
| 4910 | 4910 |
|
| 4911 | 4911 |
-- |
| 4912 |
-- Name: taxonlabel_2_propagate_canon_label_id; Type: TRIGGER; Schema: public; Owner: -
|
|
| 4912 |
-- Name: taxonlabel_2_set_canon_label_id; Type: TRIGGER; Schema: public; Owner: -
|
|
| 4913 | 4913 |
-- |
| 4914 | 4914 |
|
| 4915 |
CREATE TRIGGER taxonlabel_2_propagate_canon_label_id BEFORE INSERT OR UPDATE ON taxonlabel FOR EACH ROW EXECUTE PROCEDURE taxonlabel_2_propagate_canon_label_id();
|
|
| 4915 |
CREATE TRIGGER taxonlabel_2_set_canon_label_id BEFORE INSERT OR UPDATE ON taxonlabel FOR EACH ROW EXECUTE PROCEDURE taxonlabel_2_set_canon_label_id();
|
|
| 4916 | 4916 |
|
| 4917 | 4917 |
|
| 4918 | 4918 |
-- |
Also available in: Unified diff
schemas/vegbien.sql: taxonlabel: Renamed taxonlabel_2_propagate_canon_label_id() to taxonlabel_2_set_canon_label_id() for clarity