Revision 5462
Added by Aaron Marcuse-Kubitza about 12 years ago
| vegbien.sql | ||
|---|---|---|
| 380 | 380 |
|
| 381 | 381 |
|
| 382 | 382 |
-- |
| 383 |
-- Name: taxonconcept_canon_concept_id_self_ref(); Type: FUNCTION; Schema: public; Owner: - |
|
| 383 |
-- Name: taxonconcept_0_canon_concept_id_self_ref(); Type: FUNCTION; Schema: public; Owner: -
|
|
| 384 | 384 |
-- |
| 385 | 385 |
|
| 386 |
CREATE FUNCTION taxonconcept_canon_concept_id_self_ref() RETURNS trigger |
|
| 386 |
CREATE FUNCTION taxonconcept_0_canon_concept_id_self_ref() RETURNS trigger
|
|
| 387 | 387 |
LANGUAGE plpgsql |
| 388 | 388 |
AS $$ |
| 389 | 389 |
BEGIN |
| ... | ... | |
| 399 | 399 |
|
| 400 | 400 |
|
| 401 | 401 |
-- |
| 402 |
-- Name: taxonconcept_canon_concept_min_fit(); Type: FUNCTION; Schema: public; Owner: - |
|
| 402 |
-- Name: taxonconcept_1_canon_concept_min_fit(); Type: FUNCTION; Schema: public; Owner: -
|
|
| 403 | 403 |
-- |
| 404 | 404 |
|
| 405 |
CREATE FUNCTION taxonconcept_canon_concept_min_fit() RETURNS trigger |
|
| 405 |
CREATE FUNCTION taxonconcept_1_canon_concept_min_fit() RETURNS trigger
|
|
| 406 | 406 |
LANGUAGE plpgsql |
| 407 | 407 |
AS $$ |
| 408 | 408 |
BEGIN |
| ... | ... | |
| 4697 | 4697 |
|
| 4698 | 4698 |
|
| 4699 | 4699 |
-- |
| 4700 |
-- Name: taxonconcept_canon_concept_id_self_ref; Type: TRIGGER; Schema: public; Owner: - |
|
| 4700 |
-- Name: taxonconcept_0_canon_concept_id_self_ref; Type: TRIGGER; Schema: public; Owner: -
|
|
| 4701 | 4701 |
-- |
| 4702 | 4702 |
|
| 4703 |
CREATE TRIGGER taxonconcept_canon_concept_id_self_ref BEFORE INSERT OR UPDATE ON taxonconcept FOR EACH ROW EXECUTE PROCEDURE taxonconcept_canon_concept_id_self_ref();
|
|
| 4703 |
CREATE TRIGGER taxonconcept_0_canon_concept_id_self_ref BEFORE INSERT OR UPDATE ON taxonconcept FOR EACH ROW EXECUTE PROCEDURE taxonconcept_0_canon_concept_id_self_ref();
|
|
| 4704 | 4704 |
|
| 4705 | 4705 |
|
| 4706 | 4706 |
-- |
| 4707 |
-- Name: taxonconcept_canon_concept_min_fit; Type: TRIGGER; Schema: public; Owner: - |
|
| 4707 |
-- Name: taxonconcept_1_canon_concept_min_fit; Type: TRIGGER; Schema: public; Owner: -
|
|
| 4708 | 4708 |
-- |
| 4709 | 4709 |
|
| 4710 |
CREATE TRIGGER taxonconcept_canon_concept_min_fit BEFORE INSERT OR UPDATE ON taxonconcept FOR EACH ROW EXECUTE PROCEDURE taxonconcept_canon_concept_min_fit();
|
|
| 4710 |
CREATE TRIGGER taxonconcept_1_canon_concept_min_fit BEFORE INSERT OR UPDATE ON taxonconcept FOR EACH ROW EXECUTE PROCEDURE taxonconcept_1_canon_concept_min_fit();
|
|
| 4711 | 4711 |
|
| 4712 | 4712 |
|
| 4713 | 4713 |
-- |
Also available in: Unified diff
schemas/vegbien.sql: taxonconcept: Added order # to trigger names so they run in a defined order (triggers are run in alphabetical order)