Revision 13648
Added by Aaron Marcuse-Kubitza over 10 years ago
| trunk/schemas/vegbien.my.sql | ||
|---|---|---|
| 1555 | 1555 |
|
| 1556 | 1556 |
|
| 1557 | 1557 |
-- |
| 1558 |
-- Name: plot.**.modify(varchar(255), anyelement); Type: FUNCTION; Schema: public; Owner: - |
|
| 1559 |
-- |
|
| 1560 |
|
|
| 1561 |
|
|
| 1562 |
|
|
| 1563 |
|
|
| 1564 |
-- |
|
| 1565 |
-- Name: FUNCTION `plot.**.modify`(view_query varchar(255), schema_anchor anyelement); Type: COMMENT; Schema: public; Owner: - |
|
| 1566 |
-- |
|
| 1567 |
|
|
| 1568 |
|
|
| 1569 |
|
|
| 1570 |
|
|
| 1571 |
-- |
|
| 1558 | 1572 |
-- Name: project_contributors(int(11)); Type: FUNCTION; Schema: public; Owner: - |
| 1559 | 1573 |
-- |
| 1560 | 1574 |
|
| trunk/schemas/public_.sql | ||
|---|---|---|
| 2667 | 2667 |
|
| 2668 | 2668 |
|
| 2669 | 2669 |
-- |
| 2670 |
-- Name: plot.**.modify(text, anyelement); Type: FUNCTION; Schema: public; Owner: - |
|
| 2671 |
-- |
|
| 2672 |
|
|
| 2673 |
CREATE FUNCTION "plot.**.modify"(view_query text DEFAULT NULL::text, schema_anchor anyelement DEFAULT NULL::schema_anchor) RETURNS void |
|
| 2674 |
LANGUAGE plpgsql |
|
| 2675 |
AS $_$ |
|
| 2676 |
/* must use LANGUAGE plpgsql because LANGUAGE sql does not support runtime |
|
| 2677 |
changes of search_path (schema elements are bound at inline time rather than |
|
| 2678 |
runtime) */ |
|
| 2679 |
/* function option search_path is needed to limit the effects of |
|
| 2680 |
`SET LOCAL search_path` to the current function */ |
|
| 2681 |
BEGIN |
|
| 2682 |
PERFORM util.use_schema(schema_anchor); |
|
| 2683 |
|
|
| 2684 |
PERFORM util.recreate_view('"plot.**"', $1);
|
|
| 2685 |
END; |
|
| 2686 |
$_$; |
|
| 2687 |
|
|
| 2688 |
|
|
| 2689 |
-- |
|
| 2690 |
-- Name: FUNCTION "plot.**.modify"(view_query text, schema_anchor anyelement); Type: COMMENT; Schema: public; Owner: - |
|
| 2691 |
-- |
|
| 2692 |
|
|
| 2693 |
COMMENT ON FUNCTION "plot.**.modify"(view_query text, schema_anchor anyelement) IS ' |
|
| 2694 |
usage: |
|
| 2695 |
SELECT "plot.**.modify"($$ |
|
| 2696 |
SELECT __ |
|
| 2697 |
$$); |
|
| 2698 |
|
|
| 2699 |
idempotent |
|
| 2700 |
'; |
|
| 2701 |
|
|
| 2702 |
|
|
| 2703 |
-- |
|
| 2670 | 2704 |
-- Name: project_contributors(integer); Type: FUNCTION; Schema: public; Owner: - |
| 2671 | 2705 |
-- |
| 2672 | 2706 |
|
| trunk/schemas/vegbien.sql | ||
|---|---|---|
| 2667 | 2667 |
|
| 2668 | 2668 |
|
| 2669 | 2669 |
-- |
| 2670 |
-- Name: plot.**.modify(text, anyelement); Type: FUNCTION; Schema: public; Owner: - |
|
| 2671 |
-- |
|
| 2672 |
|
|
| 2673 |
CREATE FUNCTION "plot.**.modify"(view_query text DEFAULT NULL::text, schema_anchor anyelement DEFAULT NULL::schema_anchor) RETURNS void |
|
| 2674 |
LANGUAGE plpgsql |
|
| 2675 |
AS $_$ |
|
| 2676 |
/* must use LANGUAGE plpgsql because LANGUAGE sql does not support runtime |
|
| 2677 |
changes of search_path (schema elements are bound at inline time rather than |
|
| 2678 |
runtime) */ |
|
| 2679 |
/* function option search_path is needed to limit the effects of |
|
| 2680 |
`SET LOCAL search_path` to the current function */ |
|
| 2681 |
BEGIN |
|
| 2682 |
PERFORM util.use_schema(schema_anchor); |
|
| 2683 |
|
|
| 2684 |
PERFORM util.recreate_view('"plot.**"', $1);
|
|
| 2685 |
END; |
|
| 2686 |
$_$; |
|
| 2687 |
|
|
| 2688 |
|
|
| 2689 |
-- |
|
| 2690 |
-- Name: FUNCTION "plot.**.modify"(view_query text, schema_anchor anyelement); Type: COMMENT; Schema: public; Owner: - |
|
| 2691 |
-- |
|
| 2692 |
|
|
| 2693 |
COMMENT ON FUNCTION "plot.**.modify"(view_query text, schema_anchor anyelement) IS ' |
|
| 2694 |
usage: |
|
| 2695 |
SELECT "plot.**.modify"($$ |
|
| 2696 |
SELECT __ |
|
| 2697 |
$$); |
|
| 2698 |
|
|
| 2699 |
idempotent |
|
| 2700 |
'; |
|
| 2701 |
|
|
| 2702 |
|
|
| 2703 |
-- |
|
| 2670 | 2704 |
-- Name: project_contributors(integer); Type: FUNCTION; Schema: public; Owner: - |
| 2671 | 2705 |
-- |
| 2672 | 2706 |
|
Also available in: Unified diff
schemas/public_.sql: added plot.**.modify()