apgdiff
apgdiff copied to clipboard
Another PostgreSQL Diff Tool
**me@my_host:~/dev/my_org/my_db$** java -jar ~/lib/java/apgdiff-2.4/apgdiff-2.4.jar --ignore-start-with ./my_db.pg_dump.localhost.sql ./my_db.pg_dump.stage.sql Exception in thread "main" cz.startnet.utils.pgdiff.parsers.ParserException: Cannot parse string: ALTER TABLE public.my_databases ALTER COLUMN my_db_id ADD GENERATED ALWAYS AS IDENTITY ( SEQUENCE NAME public.my_db_id_seq...
I see references to version 2.6/2.6.0, but the latest official release is 2.4, which is 9 years old now, and not compatible with current pg versions. Can you guys please...
Running on MacOS: `java -jar apgdiff-2.6.0.jar one.sql another.sql` have: ``` Exception in thread "main" java.lang.NullPointerException: Cannot invoke "cz.startnet.utils.pgdiff.schema.PgRelation.addRule(cz.startnet.utils.pgdiff.schema.PgRule)" because the return value of "cz.startnet.utils.pgdiff.schema.PgSchema.getRelation(String)" is null at cz.startnet.utils.pgdiff.parsers.CreateRuleParser.parse(CreateRuleParser.java:74) at cz.startnet.utils.pgdiff.loader.PgDumpLoader.loadDatabaseSchema(PgDumpLoader.java:275)...
Love the utility! Is there a way to create diff file that's purely additive? We have a bunch of databases where people added random but important things, and we want...
Add Support PostgresSQL 13
Postgres supports adding elements to enumerations now. An enumeration can be incrementally updated through this syntax: alter type enum_type_name add value 'x' after 'y'; Please add support for this. Currently...
Hi everyone, I have an issue using apgdif 2.0.6 with the creation of a trigger. All the previous trigger did not cause the issue except for this one. The issue...
fixed schema name for triggers, constraints during parsing comments fixed parser function 'expectOptional' fixed null referenced exceptions in PgDiffTriggers and PgDiffViews
I updated CreateSequenceParser.java and CreateIndexParser.java, fixed the function _parse(final PgDatabase database, final String statement)_ for both of them
how do we generate the jar file given the repo? ty can someone put this in the readme? oh it's in the releases directory? good to know