apgdiff icon indicating copy to clipboard operation
apgdiff copied to clipboard

Another PostgreSQL Diff Tool

Results 105 apgdiff issues
Sort by recently updated
recently updated
newest added

Exception in thread "main" cz.startnet.utils.pgdiff.parsers.ParserException: Cannot find column 'id' in table 'ir_act_client' at cz.startnet.utils.pgdiff.parsers.AlterTableParser.parseAlterColumn(AlterTableParser.java:266) at cz.startnet.utils.pgdiff.parsers.AlterTableParser.parse(AlterTableParser.java:79) at cz.startnet.utils.pgdiff.loader.PgDumpLoader.loadDatabaseSchema(PgDumpLoader.java:180) at cz.startnet.utils.pgdiff.loader.PgDumpLoader.loadDatabaseSchema(PgDumpLoader.java:236) at cz.startnet.utils.pgdiff.PgDiff.createDiff(PgDiff.java:29) at cz.startnet.utils.pgdiff.Main.main(Main.java:39) Ubuntu 12.04 pg9.1 apgdiff-2.4 (bin) Thanks

bug

Add --ignore-constraint-names option to compare constraints using only the definition

I have an ALTER TABLE statement in my SQL dump file: ALTER TABLE ONLY v_device_list REPLICA IDENTITY NOTHING; I dont exactly know what is "REPLICA IDENTITY NOTHING". This cause the...

enhancement

Fix column access privilege parsing. Fix search-path output for privilege-only diffs in a multi-schema scenario. Both fixes have test-cases.

Possible fix for https://github.com/fordfrog/apgdiff/issues/208

create colunm comparator for rename column

Hi. I had some problems with updating functions with your diff utility. When function's signature were changed CREATE OR REPLACE statement fails, so I have added new --force-drop-function command line...

```Exception in thread "main" cz.startnet.utils.pgdiff.parsers.ParserException: Cannot parse string: ALTER SEQUENCE mySchema.mySeq_pk_autoincrement OWNER TO someUser;``` ```Unsupported command at position 47 'OWNER TO someUser;' at cz.startnet.utils.pgdiff.parsers.Parser.throwUnsupportedCommand(Parser.java:402) at cz.startnet.utils.pgdiff.parsers.AlterSequenceParser.parse(AlterSequenceParser.java:64) at cz.startnet.utils.pgdiff.loader.PgDumpLoader.loadDatabaseSchema(PgDumpLoader.java:219) at cz.startnet.utils.pgdiff.loader.PgDumpLoader.loadDatabaseSchema(PgDumpLoader.java:277)...

I am getting an uncaught Java exception. I did not see a debug output option in the man page for apgdiff otherwise I would try to post more meaningful context...

apgdiff raises an exception when diffing schema having inherited tables. apgdiff version is: 2.4 Command used: apgdiff ir_actions.6.schema.sql ir_actions.8.schema.sql Exception: > Exception in thread "main" cz.startnet.utils.pgdiff.parsers.ParserException: Cannot find column 'id'...