Revision 3396
Added by Aaron Marcuse-Kubitza over 12 years ago
| py_functions.sql | ||
|---|---|---|
| 9 | 9 |
SET client_min_messages = warning; |
| 10 | 10 |
SET escape_string_warning = off; |
| 11 | 11 |
|
| 12 |
SET SESSION AUTHORIZATION 'bien'; |
|
| 13 |
|
|
| 12 | 14 |
-- |
| 13 | 15 |
-- Name: py_functions; Type: SCHEMA; Schema: -; Owner: bien |
| 14 | 16 |
-- |
| ... | ... | |
| 16 | 18 |
CREATE SCHEMA py_functions; |
| 17 | 19 |
|
| 18 | 20 |
|
| 19 |
ALTER SCHEMA py_functions OWNER TO bien; |
|
| 20 |
|
|
| 21 | 21 |
SET search_path = py_functions, pg_catalog; |
| 22 | 22 |
|
| 23 | 23 |
-- |
| ... | ... | |
| 34 | 34 |
$$; |
| 35 | 35 |
|
| 36 | 36 |
|
| 37 |
ALTER FUNCTION py_functions."_dateRangeEnd"() OWNER TO bien; |
|
| 38 |
|
|
| 39 | 37 |
-- |
| 40 | 38 |
-- Name: _dateRangeEnd(text); Type: FUNCTION; Schema: py_functions; Owner: bien |
| 41 | 39 |
-- |
| ... | ... | |
| 47 | 45 |
$_$; |
| 48 | 46 |
|
| 49 | 47 |
|
| 50 |
ALTER FUNCTION py_functions."_dateRangeEnd"(value text) OWNER TO bien; |
|
| 51 |
|
|
| 52 | 48 |
-- |
| 53 | 49 |
-- Name: _dateRangeStart(); Type: FUNCTION; Schema: py_functions; Owner: bien |
| 54 | 50 |
-- |
| ... | ... | |
| 63 | 59 |
$$; |
| 64 | 60 |
|
| 65 | 61 |
|
| 66 |
ALTER FUNCTION py_functions."_dateRangeStart"() OWNER TO bien; |
|
| 67 |
|
|
| 68 | 62 |
-- |
| 69 | 63 |
-- Name: _dateRangeStart(text); Type: FUNCTION; Schema: py_functions; Owner: bien |
| 70 | 64 |
-- |
| ... | ... | |
| 76 | 70 |
$_$; |
| 77 | 71 |
|
| 78 | 72 |
|
| 79 |
ALTER FUNCTION py_functions."_dateRangeStart"(value text) OWNER TO bien; |
|
| 80 |
|
|
| 81 | 73 |
-- |
| 82 | 74 |
-- Name: _namePart(); Type: FUNCTION; Schema: py_functions; Owner: bien |
| 83 | 75 |
-- |
| ... | ... | |
| 92 | 84 |
$$; |
| 93 | 85 |
|
| 94 | 86 |
|
| 95 |
ALTER FUNCTION py_functions."_namePart"() OWNER TO bien; |
|
| 96 |
|
|
| 97 | 87 |
-- |
| 98 | 88 |
-- Name: _namePart(text, text, text); Type: FUNCTION; Schema: py_functions; Owner: bien |
| 99 | 89 |
-- |
| ... | ... | |
| 130 | 120 |
$$; |
| 131 | 121 |
|
| 132 | 122 |
|
| 133 |
ALTER FUNCTION py_functions."_namePart"(first text, middle text, last text) OWNER TO bien; |
|
| 134 |
|
|
| 135 | 123 |
-- |
| 136 | 124 |
-- Name: parse_date_range(text); Type: FUNCTION; Schema: py_functions; Owner: bien |
| 137 | 125 |
-- |
| ... | ... | |
| 173 | 161 |
$$; |
| 174 | 162 |
|
| 175 | 163 |
|
| 176 |
ALTER FUNCTION py_functions.parse_date_range(str_ text) OWNER TO bien; |
|
| 177 |
|
|
| 178 | 164 |
SET default_tablespace = ''; |
| 179 | 165 |
|
| 180 | 166 |
SET default_with_oids = false; |
| ... | ... | |
| 190 | 176 |
); |
| 191 | 177 |
|
| 192 | 178 |
|
| 193 |
ALTER TABLE py_functions."_dateRangeEnd" OWNER TO bien; |
|
| 194 |
|
|
| 195 | 179 |
-- |
| 196 | 180 |
-- Name: _dateRangeStart; Type: TABLE; Schema: py_functions; Owner: bien; Tablespace: |
| 197 | 181 |
-- |
| ... | ... | |
| 203 | 187 |
); |
| 204 | 188 |
|
| 205 | 189 |
|
| 206 |
ALTER TABLE py_functions."_dateRangeStart" OWNER TO bien; |
|
| 207 |
|
|
| 208 | 190 |
-- |
| 209 | 191 |
-- Name: _namePart; Type: TABLE; Schema: py_functions; Owner: bien; Tablespace: |
| 210 | 192 |
-- |
| ... | ... | |
| 218 | 200 |
); |
| 219 | 201 |
|
| 220 | 202 |
|
| 221 |
ALTER TABLE py_functions."_namePart" OWNER TO bien; |
|
| 222 |
|
|
| 223 | 203 |
-- |
| 224 | 204 |
-- Name: _dateRangeEnd_unique; Type: INDEX; Schema: py_functions; Owner: bien; Tablespace: |
| 225 | 205 |
-- |
Also available in: Unified diff
pg_dump_vegbien: Use SET SESSION AUTHORIZATION to ensure that owners are always recorded in the same format. This will help make plain text backups comparable using diff.