Hello,

 

We tested the VERSION (6.1.0.1650) and there is the errors:

 

-          About use the file metadata dbcomparer.sql 

1  The command ALTER SCHEMA is not recognize; 

        EX: ALTER SCHEMA teste OWNER TO postgres;

2  The operator IN in command CREATE FUNCTION still not recognize;  

        Ex: CREATE FUNCTION fn_teste_in(IN iid integer, OUT oid integer, OUT oinfo character varying) RETURNS SETOF record ...

              ALTER FUNCTION teste.fn_teste_in(IN iid integer, OUT oid integer, OUT oinfo character varying) OWNER TO postgres;

3 - CREATE FUNCTION the has a type with result is not recognize

       Ex: CREATE FUNCTION fn_teste_type(iid integer) RETURNS SETOF tp_teste ...

4 - Command CREATE SEQUENCE still not recognize

      Ex: CREATE SEQUENCE sq_teste ...

5 - Command CREATE RULE is not working, but we checked in last update script some changes;

      Ex: CREATE RULE rl_teste_insert AS ON INSERT TO vi_teste DO INSTEAD INSERT INTO tb_teste (id, info) VALUES (new.id, new.info);

6 - Command CREATE TYPE is not declare the schema, to not declare the schema in command, is necessary to use the command  SET search_path

Ex: CREATE TYPE teste.tp_teste AS (cod integer, nome varchar(200));

                              or

    SET search_path = teste, pg_catalog; CREATE TYPE tp_teste AS (cod integer, nome varchar(200));

 

 

-          About use the database create by file dbcomparer.sql 

1  the value DEFAULT about command DOMAIN is not use

Ex: CREATE DOMAIN dm_numero integer default 0;

2 -  command CREATE RULE is not working, we checked in last update script some changes;

Ex: CREATE RULE rl_teste_insert AS ON INSERT TO vi_teste DO INSTEAD INSERT INTO tb_teste (id, info) VALUES (new.id, new.info);

3  commando CREATE TYPE is not declare the schema, (like number 6 above)

      Ex: CREATE TYPE teste.tp_teste AS (cod integer, nome varchar(200));

                              or

    SET search_path = teste, pg_catalog; CREATE TYPE tp_teste AS (cod integer, nome varchar(200));

4  when extract the functions, the parameters after a specify parameter with operator  IN is not working

     Ex: CREATE FUNCTION teste.fn_teste_in(IN iid integer, OUT oid integer, OUT oinfo character varying) RETURNS SETOF record ...

                        Return only

    CREATE FUNCTION teste.fn_teste_in(in iid integer) RETURNS SETOF record ...
