Revision 12010
Added by Aaron Marcuse-Kubitza almost 11 years ago
| trunk/schemas/vegbien.my.sql | ||
|---|---|---|
| 451 | 451 |
|
| 452 | 452 |
|
| 453 | 453 |
-- |
| 454 |
-- Name: locationevent__pull_forward_from_parent(); Type: FUNCTION; Schema: public; Owner: -
|
|
| 454 |
-- Name: locationevent_pull_forward_from_parent_for_stratum(); Type: FUNCTION; Schema: public; Owner: -
|
|
| 455 | 455 |
-- |
| 456 | 456 |
|
| 457 | 457 |
|
| 458 | 458 |
|
| 459 | 459 |
|
| 460 | 460 |
-- |
| 461 |
-- Name: FUNCTION locationevent__pull_forward_from_parent(); Type: COMMENT; Schema: public; Owner: -
|
|
| 461 |
-- Name: FUNCTION locationevent_pull_forward_from_parent_for_stratum(); Type: COMMENT; Schema: public; Owner: -
|
|
| 462 | 462 |
-- |
| 463 | 463 |
|
| 464 | 464 |
|
| ... | ... | |
| 7861 | 7861 |
|
| 7862 | 7862 |
|
| 7863 | 7863 |
-- |
| 7864 |
-- Name: locationevent__pull_forward_from_parent; Type: TRIGGER; Schema: public; Owner: -
|
|
| 7864 |
-- Name: locationevent_pull_forward_from_parent_for_stratum; Type: TRIGGER; Schema: public; Owner: -
|
|
| 7865 | 7865 |
-- |
| 7866 | 7866 |
|
| 7867 | 7867 |
|
| trunk/schemas/vegbien.sql | ||
|---|---|---|
| 880 | 880 |
|
| 881 | 881 |
|
| 882 | 882 |
-- |
| 883 |
-- Name: locationevent__pull_forward_from_parent(); Type: FUNCTION; Schema: public; Owner: -
|
|
| 883 |
-- Name: locationevent_pull_forward_from_parent_for_stratum(); Type: FUNCTION; Schema: public; Owner: -
|
|
| 884 | 884 |
-- |
| 885 | 885 |
|
| 886 |
CREATE FUNCTION locationevent__pull_forward_from_parent() RETURNS trigger
|
|
| 886 |
CREATE FUNCTION locationevent_pull_forward_from_parent_for_stratum() RETURNS trigger
|
|
| 887 | 887 |
LANGUAGE plpgsql |
| 888 | 888 |
AS $$ |
| 889 | 889 |
DECLARE |
| ... | ... | |
| 899 | 899 |
|
| 900 | 900 |
|
| 901 | 901 |
-- |
| 902 |
-- Name: FUNCTION locationevent__pull_forward_from_parent(); Type: COMMENT; Schema: public; Owner: -
|
|
| 902 |
-- Name: FUNCTION locationevent_pull_forward_from_parent_for_stratum(); Type: COMMENT; Schema: public; Owner: -
|
|
| 903 | 903 |
-- |
| 904 | 904 |
|
| 905 |
COMMENT ON FUNCTION locationevent__pull_forward_from_parent() IS 'see wiki.vegpath.org/Pull-forward';
|
|
| 905 |
COMMENT ON FUNCTION locationevent_pull_forward_from_parent_for_stratum() IS 'see wiki.vegpath.org/Pull-forward';
|
|
| 906 | 906 |
|
| 907 | 907 |
|
| 908 | 908 |
-- |
| ... | ... | |
| 9478 | 9478 |
|
| 9479 | 9479 |
|
| 9480 | 9480 |
-- |
| 9481 |
-- Name: locationevent__pull_forward_from_parent; Type: TRIGGER; Schema: public; Owner: -
|
|
| 9481 |
-- Name: locationevent_pull_forward_from_parent_for_stratum; Type: TRIGGER; Schema: public; Owner: -
|
|
| 9482 | 9482 |
-- |
| 9483 | 9483 |
|
| 9484 |
CREATE TRIGGER locationevent__pull_forward_from_parent BEFORE INSERT OR UPDATE OF locationevent_id, parent_id ON locationevent FOR EACH ROW WHEN (((new.parent_id IS NOT NULL) AND (new.stratum_id IS NOT NULL))) EXECUTE PROCEDURE locationevent__pull_forward_from_parent();
|
|
| 9484 |
CREATE TRIGGER locationevent_pull_forward_from_parent_for_stratum BEFORE INSERT OR UPDATE OF locationevent_id, parent_id ON locationevent FOR EACH ROW WHEN (((new.parent_id IS NOT NULL) AND (new.stratum_id IS NOT NULL))) EXECUTE PROCEDURE locationevent_pull_forward_from_parent_for_stratum();
|
|
| 9485 | 9485 |
|
| 9486 | 9486 |
|
| 9487 | 9487 |
-- |
Also available in: Unified diff
schemas/vegbien.sql: locationevent__pull_forward_from_parent(): renamed to locationevent_pull_forward_from_parent_for_stratum() since it actually has a filter that causes it to apply only to stratum events