apgdiff icon indicating copy to clipboard operation
apgdiff copied to clipboard

Cannot find column of inherited table

Open olilau opened this issue 8 years ago • 1 comments

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' in table 'ir_act_report_custom' 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)

ir_actions.6.schema.sql: http://pastebin.com/ubUyXpWW

ir_actions.8.schema.sql: http://pastebin.com/V8zSAwDY

Thanks.

olilau avatar Feb 15 '17 12:02 olilau

using version 2.4 Ran into the same problem

java -jar apgdiff-2.4.jar /usr/local/db_dumps/db1.sql /usr/local/db_dumps/db2.sql >> /usr/local/db_dumps/output.sql
Exception in thread "main" cz.startnet.utils.pgdiff.parsers.ParserException: Cannot find column 'created_by' in table 'academic_plan'
	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)

ckremser avatar Feb 28 '17 20:02 ckremser