regression.diffs

*** /Users/rngadam/coderbunker/prj/scryinfo/pgddl/test/expected/type.out	2018-03-26 23:41:47.000000000 +0800
--- /Users/rngadam/coderbunker/prj/scryinfo/pgddl/results/type.out	2018-03-27 00:00:25.000000000 +0800
***************
*** 98,104 ****
  -- DROP DOMAIN test_collation_d;
  
  CREATE DOMAIN test_collation_d AS text
!   COLLATE "en_US.utf8"
    DEFAULT '***'::text;
  
  COMMENT ON DOMAIN test_collation_d IS NULL;
--- 98,104 ----
  -- DROP DOMAIN test_collation_d;
  
  CREATE DOMAIN test_collation_d AS text
!   COLLATE "en_US"
    DEFAULT '***'::text;
  
  COMMENT ON DOMAIN test_collation_d IS NULL;
***************
*** 128,134 ****
  );
  
  COMMENT ON TYPE integer IS '-2 billion to 2 billion integer, 4-byte storage';
! ALTER TYPE integer OWNER TO postgres;
  END;
  
  (1 row)
--- 128,134 ----
  );
  
  COMMENT ON TYPE integer IS '-2 billion to 2 billion integer, 4-byte storage';
! ALTER TYPE integer OWNER TO rngadam;
  END;
  
  (1 row)
***************
*** 155,161 ****
  );
  
  COMMENT ON TYPE integer[] IS NULL;
! ALTER TYPE integer[] OWNER TO postgres;
  END;
  
  (1 row)
--- 155,161 ----
  );
  
  COMMENT ON TYPE integer[] IS NULL;
! ALTER TYPE integer[] OWNER TO rngadam;
  END;
  
  (1 row)
***************
*** 180,186 ****
  );
  
  COMMENT ON TYPE uuid IS 'UUID datatype';
! ALTER TYPE uuid OWNER TO postgres;
  END;
  
  (1 row)
--- 180,186 ----
  );
  
  COMMENT ON TYPE uuid IS 'UUID datatype';
! ALTER TYPE uuid OWNER TO rngadam;
  END;
  
  (1 row)
***************
*** 206,212 ****
  );
  
  COMMENT ON TYPE text IS 'variable-length string, no limit specified';
! ALTER TYPE text OWNER TO postgres;
  END;
  
  (1 row)
--- 206,212 ----
  );
  
  COMMENT ON TYPE text IS 'variable-length string, no limit specified';
! ALTER TYPE text OWNER TO rngadam;
  END;
  
  (1 row)
***************
*** 231,237 ****
  );
  
  COMMENT ON TYPE xml IS 'XML content';
! ALTER TYPE xml OWNER TO postgres;
  END;
  
  (1 row)
--- 231,237 ----
  );
  
  COMMENT ON TYPE xml IS 'XML content';
! ALTER TYPE xml OWNER TO rngadam;
  END;
  
  (1 row)
***************
*** 250,256 ****
  );
  
  COMMENT ON TYPE daterange IS 'range of dates';
! ALTER TYPE daterange OWNER TO postgres;
  END;
  
  (1 row)
--- 250,256 ----
  );
  
  COMMENT ON TYPE daterange IS 'range of dates';
! ALTER TYPE daterange OWNER TO rngadam;
  END;
  
  (1 row)
***************
*** 274,280 ****
  );
  
  COMMENT ON OPERATOR =(integer,integer) IS 'equal';
! ALTER OPERATOR =(integer,integer) OWNER TO postgres;
  END;
  
  (1 row)
--- 274,280 ----
  );
  
  COMMENT ON OPERATOR =(integer,integer) IS 'equal';
! ALTER OPERATOR =(integer,integer) OWNER TO rngadam;
  END;
  
  (1 row)
***************
*** 298,304 ****
  );
  
  COMMENT ON OPERATOR =(text,text) IS 'equal';
! ALTER OPERATOR =(text,text) OWNER TO postgres;
  END;
  
  (1 row)
--- 298,304 ----
  );
  
  COMMENT ON OPERATOR =(text,text) IS 'equal';
! ALTER OPERATOR =(text,text) OWNER TO rngadam;
  END;
  
  (1 row)

======================================================================

*** /Users/rngadam/coderbunker/prj/scryinfo/pgddl/test/expected/class.out	2018-03-26 23:41:47.000000000 +0800
--- /Users/rngadam/coderbunker/prj/scryinfo/pgddl/results/class.out	2018-03-27 00:00:26.000000000 +0800
***************
*** 431,437 ****
  CREATE TABLE test_collation (
      id integer NOT NULL,
      c text COLLATE "C" NOT NULL,
!     en text COLLATE "en_US.utf8",
      t text
  );
  
--- 431,437 ----
  CREATE TABLE test_collation (
      id integer NOT NULL,
      c text COLLATE "C" NOT NULL,
!     en text COLLATE "en_US",
      t text
  );
  

======================================================================

*** /Users/rngadam/coderbunker/prj/scryinfo/pgddl/test/expected/fdw.out	2018-03-26 18:22:55.000000000 +0800
--- /Users/rngadam/coderbunker/prj/scryinfo/pgddl/results/fdw.out	2018-03-27 00:00:27.000000000 +0800
***************
*** 49,54 ****
--- 49,61 ----
   COMMENT ON COLUMN test_class_f.line IS 'A Line of text';    +
                                                               +
   ALTER FOREIGN TABLE test_class_f OWNER TO postgres;         +
+  GRANT INSERT ON test_class_f TO PUBLIC;                     +
+  GRANT SELECT ON test_class_f TO PUBLIC;                     +
+  GRANT UPDATE ON test_class_f TO PUBLIC;                     +
+  GRANT DELETE ON test_class_f TO PUBLIC;                     +
+  GRANT TRUNCATE ON test_class_f TO PUBLIC;                   +
+  GRANT REFERENCES ON test_class_f TO PUBLIC;                 +
+  GRANT TRIGGER ON test_class_f TO PUBLIC;                    +
   END;                                                        +
   
  (1 row)

======================================================================

*** /Users/rngadam/coderbunker/prj/scryinfo/pgddl/test/expected/misc.out	2018-03-26 18:22:55.000000000 +0800
--- /Users/rngadam/coderbunker/prj/scryinfo/pgddl/results/misc.out	2018-03-27 00:00:27.000000000 +0800
***************
*** 40,46 ****
  ---------------------------------------------------------------------------------------
   CREATE TEXT SEARCH CONFIGURATION english ( PARSER = pg_catalog."default" );          +
   COMMENT ON TEXT SEARCH CONFIGURATION english IS 'configuration for english language';+
!  ALTER TEXT SEARCH CONFIGURATION english OWNER TO postgres;                           +
   
  (1 row)
  
--- 40,46 ----
  ---------------------------------------------------------------------------------------
   CREATE TEXT SEARCH CONFIGURATION english ( PARSER = pg_catalog."default" );          +
   COMMENT ON TEXT SEARCH CONFIGURATION english IS 'configuration for english language';+
!  ALTER TEXT SEARCH CONFIGURATION english OWNER TO rngadam;                            +
   
  (1 row)
  
***************
*** 57,63 ****
   CREATE TEXT SEARCH DICTIONARY english_stem                                                +
     ( TEMPLATE = pg_catalog.snowball, language = 'english', stopwords = 'english' );        +
   COMMENT ON TEXT SEARCH DICTIONARY english_stem IS 'snowball stemmer for english language';+
!  ALTER TEXT SEARCH DICTIONARY english_stem OWNER TO postgres;                              +
   
  (1 row)
  
--- 57,63 ----
   CREATE TEXT SEARCH DICTIONARY english_stem                                                +
     ( TEMPLATE = pg_catalog.snowball, language = 'english', stopwords = 'english' );        +
   COMMENT ON TEXT SEARCH DICTIONARY english_stem IS 'snowball stemmer for english language';+
!  ALTER TEXT SEARCH DICTIONARY english_stem OWNER TO rngadam;                               +
   
  (1 row)
  
***************
*** 73,79 ****
  ----------------------------------------------------------------------------
   CREATE TEXT SEARCH CONFIGURATION simple ( PARSER = pg_catalog."default" );+
   COMMENT ON TEXT SEARCH CONFIGURATION simple IS 'simple configuration';    +
!  ALTER TEXT SEARCH CONFIGURATION simple OWNER TO postgres;                 +
   
  (1 row)
  
--- 73,79 ----
  ----------------------------------------------------------------------------
   CREATE TEXT SEARCH CONFIGURATION simple ( PARSER = pg_catalog."default" );+
   COMMENT ON TEXT SEARCH CONFIGURATION simple IS 'simple configuration';    +
!  ALTER TEXT SEARCH CONFIGURATION simple OWNER TO rngadam;                  +
   
  (1 row)
  
***************
*** 83,89 ****
   CREATE TEXT SEARCH DICTIONARY simple                                                                    +
     ( TEMPLATE = pg_catalog.simple );                                                                     +
   COMMENT ON TEXT SEARCH DICTIONARY simple IS 'simple dictionary: just lower case and check for stopword';+
!  ALTER TEXT SEARCH DICTIONARY simple OWNER TO postgres;                                                  +
   
  (1 row)
  
--- 83,89 ----
   CREATE TEXT SEARCH DICTIONARY simple                                                                    +
     ( TEMPLATE = pg_catalog.simple );                                                                     +
   COMMENT ON TEXT SEARCH DICTIONARY simple IS 'simple dictionary: just lower case and check for stopword';+
!  ALTER TEXT SEARCH DICTIONARY simple OWNER TO rngadam;                                                   +
   
  (1 row)
  

======================================================================