Project

General

Profile

« Previous | Next » 

Revision 1932

schemas/vegbien.sql.make: Fixed bug where data sources' schemas were also exported by exporting only the public schema. Note that this also removes the "CREATE OR REPLACE PROCEDURAL LANGUAGE plpgsql" statement, so that it doesn't have to be filtered out with `grep -v`.

View differences:

schemas/vegbien.sql.make
3 3

  
4 4
selfDir="$(dirname -- "$0")"
5 5

  
6
"$selfDir/../bin/postgres_vegbien" pg_dump --schema-only --no-owner \
7
--no-privileges|grep -v -F "CREATE OR REPLACE PROCEDURAL LANGUAGE plpgsql"
6
"$selfDir/../bin/postgres_vegbien" pg_dump --schema=public --schema-only \
7
--no-owner --no-privileges
schemas/vegbien.my.sql
9 9

  
10 10

  
11 11

  
12
--
13
-- Name: plpgsql; Type: PROCEDURAL LANGUAGE; Schema: -; Owner: -
14
--
15 12

  
16 13

  
17

  
18

  
19

  
20 14
--
21 15
-- Name: establishmentmeans_dwc; Type: TYPE; Schema: public; Owner: -
22 16
--
schemas/vegbien.sql
9 9
SET client_min_messages = warning;
10 10
SET escape_string_warning = off;
11 11

  
12
--
13
-- Name: plpgsql; Type: PROCEDURAL LANGUAGE; Schema: -; Owner: -
14
--
15

  
16

  
17

  
18 12
SET search_path = public, pg_catalog;
19 13

  
20 14
--

Also available in: Unified diff