apgdiff
apgdiff copied to clipboard
apgdiff chokes on 'GRANT CREATE ON SCHEMA'
I'm seeing this with the most recent clone of the repo (commit a9e43b46afc53c31d10be591366b3ba811c223db from August 11th).
Consider the simple dump that I've pasted here: http://pastebin.com/bSzbUjXn
When doing a diff on this, the line GRANT CREATE ON SCHEMA public TO test_user;
results in a ParserException:
Exception in thread "main" cz.startnet.utils.pgdiff.parsers.ParserException: Cannot parse string: GRANT CREATE ON SCHEMA public TO test_user; Expected TO at position 14 'ON SCHEMA public TO ' at cz.startnet.utils.pgdiff.parsers.Parser.expect(Parser.java:91) at cz.startnet.utils.pgdiff.parsers.Parser.expect(Parser.java:47) at cz.startnet.utils.pgdiff.parsers.GrantRevokeParser.parse(GrantRevokeParser.java:152) at cz.startnet.utils.pgdiff.loader.PgDumpLoader.loadDatabaseSchema(PgDumpLoader.java:240) at cz.startnet.utils.pgdiff.loader.PgDumpLoader.loadDatabaseSchema(PgDumpLoader.java:277) at cz.startnet.utils.pgdiff.PgDiff.createDiff(PgDiff.java:30) at cz.startnet.utils.pgdiff.Main.main(Main.java:39)
Thanks! Taylor