Project

General

Profile

« Previous | Next » 

Revision 3396

Added by Aaron Marcuse-Kubitza over 12 years ago

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.

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
  
    

  		




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


  		












  

    
      bin/pg_dump_vegbien
    
  





  16
  16
  
    
test -n "$owners" && ownerOpts= || ownerOpts='--no-owner --no-privileges'


  		




  17
  17
  
    

  		




  18
  18
  
    
(set -x; "$selfDir/../bin/postgres_vegbien" pg_dump --schema="\"$1\"" \


  		




  19
  
  
    
$dataOpts $ownerOpts)


  		




  
  19
  
    
$dataOpts $ownerOpts --use-set-session-authorization)


  		












Also available in:  Unified diff