apgdiff icon indicating copy to clipboard operation
apgdiff copied to clipboard

apgdiff chokes on 'GRANT CREATE ON SCHEMA'

Open taylorreece opened this issue 8 years ago • 0 comments

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

taylorreece avatar Oct 12 '16 22:10 taylorreece