Project

General

Profile

« Previous | Next » 

Revision 3430

Added by Aaron Marcuse-Kubitza over 12 years ago

pg_dump_vegbien: Don't use SET SESSION AUTHORIZATION because it doesn't work with the py_functions schema (it requires PL/Python functions to be created as user postgres and then the owner changed to bien, which SET SESSION AUTHORIZATION won't do)

View differences:

schemas/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
  
  
    

  		




  14
  12
  
    
--


  		




  15
  13
  
    
-- Name: py_functions; Type: SCHEMA; Schema: -; Owner: bien


  		




  16
  14
  
    
--


  		




  ......




  18
  16
  
    
CREATE SCHEMA py_functions;


  		




  19
  17
  
    

  		




  20
  18
  
    

  		




  
  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
  
    

  		




  37
  39
  
    
--


  		




  38
  40
  
    
-- Name: __dateRangeStart(); Type: FUNCTION; Schema: py_functions; Owner: bien


  		




  39
  41
  
    
--


  		




  ......




  48
  50
  
    
$$;


  		




  49
  51
  
    

  		




  50
  52
  
    

  		




  
  53
  
    
ALTER FUNCTION py_functions."__dateRangeStart"() OWNER TO bien;


  		




  
  54
  
    

  		




  51
  55
  
    
--


  		




  52
  56
  
    
-- Name: __namePart(); Type: FUNCTION; Schema: py_functions; Owner: bien


  		




  53
  57
  
    
--


  		




  ......




  62
  66
  
    
$$;


  		




  63
  67
  
    

  		




  64
  68
  
    

  		




  
  69
  
    
ALTER FUNCTION py_functions."__namePart"() OWNER TO bien;


  		




  
  70
  
    

  		




  65
  71
  
    
--


  		




  66
  72
  
    
-- Name: _date(text, text, text, text); Type: FUNCTION; Schema: py_functions; Owner: bien


  		




  67
  73
  
    
--


  		




  ......




  142
  148
  
    
$$;


  		




  143
  149
  
    

  		




  144
  150
  
    

  		




  
  151
  
    
ALTER FUNCTION py_functions._date(date text, year text, month text, day text) OWNER TO bien;


  		




  
  152
  
    

  		




  145
  153
  
    
--


  		




  146
  154
  
    
-- Name: _dateRangeEnd(text); Type: FUNCTION; Schema: py_functions; Owner: bien


  		




  147
  155
  
    
--


  		




  ......




  153
  161
  
    
$_$;


  		




  154
  162
  
    

  		




  155
  163
  
    

  		




  
  164
  
    
ALTER FUNCTION py_functions."_dateRangeEnd"(value text) OWNER TO bien;


  		




  
  165
  
    

  		




  156
  166
  
    
--


  		




  157
  167
  
    
-- Name: _dateRangeStart(text); Type: FUNCTION; Schema: py_functions; Owner: bien


  		




  158
  168
  
    
--


  		




  ......




  164
  174
  
    
$_$;


  		




  165
  175
  
    

  		




  166
  176
  
    

  		




  
  177
  
    
ALTER FUNCTION py_functions."_dateRangeStart"(value text) OWNER TO bien;


  		




  
  178
  
    

  		




  167
  179
  
    
--


  		




  168
  180
  
    
-- Name: _namePart(text, text, text); Type: FUNCTION; Schema: py_functions; Owner: bien


  		




  169
  181
  
    
--


  		




  ......




  200
  212
  
    
$$;


  		




  201
  213
  
    

  		




  202
  214
  
    

  		




  
  215
  
    
ALTER FUNCTION py_functions."_namePart"(first text, middle text, last text) OWNER TO bien;


  		




  
  216
  
    

  		




  203
  217
  
    
--


  		




  204
  218
  
    
-- Name: parse_date_range(text); Type: FUNCTION; Schema: py_functions; Owner: bien


  		




  205
  219
  
    
--


  		




  ......




  241
  255
  
    
$$;


  		




  242
  256
  
    

  		




  243
  257
  
    

  		




  
  258
  
    
ALTER FUNCTION py_functions.parse_date_range(str_ text) OWNER TO bien;


  		




  
  259
  
    

  		




  244
  260
  
    
SET default_tablespace = '';


  		




  245
  261
  
    

  		




  246
  262
  
    
SET default_with_oids = false;


  		




  ......




  256
  272
  
    
);


  		




  257
  273
  
    

  		




  258
  274
  
    

  		




  
  275
  
    
ALTER TABLE py_functions."_dateRangeEnd" OWNER TO bien;


  		




  
  276
  
    

  		




  259
  277
  
    
--


  		




  260
  278
  
    
-- Name: _dateRangeStart; Type: TABLE; Schema: py_functions; Owner: bien; Tablespace: 


  		




  261
  279
  
    
--


  		




  ......




  267
  285
  
    
);


  		




  268
  286
  
    

  		




  269
  287
  
    

  		




  
  288
  
    
ALTER TABLE py_functions."_dateRangeStart" OWNER TO bien;


  		




  
  289
  
    

  		




  270
  290
  
    
--


  		




  271
  291
  
    
-- Name: _namePart; Type: TABLE; Schema: py_functions; Owner: bien; Tablespace: 


  		




  272
  292
  
    
--


  		




  ......




  280
  300
  
    
);


  		




  281
  301
  
    

  		




  282
  302
  
    

  		




  
  303
  
    
ALTER TABLE py_functions."_namePart" OWNER TO bien;


  		




  
  304
  
    

  		




  283
  305
  
    
--


  		




  284
  306
  
    
-- Name: _dateRangeEnd_unique; Type: INDEX; Schema: py_functions; Owner: bien; Tablespace: 


  		




  285
  307
  
    
--


  		












  

    
      bin/pg_dump_vegbien
    
  





  21
  21
  
    
else set -- "$@" --schema-only


  		




  22
  22
  
    
fi


  		




  23
  23
  
    
test -n "$owners" || set -- "$@" --no-owner --no-privileges


  		




  24
  
  
    
set -- "$@" --use-set-session-authorization


  		




  
  24
  
    
set -- "$@"


  		




  25
  25
  
    

  		




  26
  26
  
    
set -x


  		




  27
  27
  
    
exec "$selfDir/postgres_vegbien" pg_dump "$@"


  		












Also available in:  Unified diff