apgdiff
apgdiff copied to clipboard
fordfrog
Another PostgreSQL Diff Tool
When I tried the tool for the first time, I am getting the following error: ``` Exception in thread "main" java.lang.StringIndexOutOfBoundsException: String index out of range: -13 at java.lang.String.substring(Unknown Source)...
There are some "temporary" tables that are left over from a migration or ETL process that only exists on the production system. I don't like to drop those as they...
``` Exception in thread "main" java.lang.RuntimeException: Cannot find schema 'data' for statement 'CREATE TABLE IF NOT EXISTS data.app ... Missing CREATE SCHEMA statement? at cz.startnet.utils.pgdiff.parsers.CreateTableParser.parse(CreateTableParser.java:44) at cz.startnet.utils.pgdiff.loader.PgDumpLoader.loadDatabaseSchema(PgDumpLoader.java:178) at cz.startnet.utils.pgdiff.loader.PgDumpLoader.loadDatabaseSchema(PgDumpLoader.java:236) at...
When diffing two databases with the following particularities : - The newer has new tables - Some new tables are referencing new tables - Some referenced new tables have unique...
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...
It is possible to split the alter column, because currently all definitions of a column are in the same alter. Here is an exemple **origin-table**: ``` CREATE TABLE "acl"( "id"...
Especially when e.g. comparing local copies to production databases you rarely care about these, and with big database the (otherwise possibly empty) diff is unreadable due to all the spam...
When I have these two definitions: ``` CREATE TABLE users ( id SERIAL, email VARCHAR NOT NULL, last_login TIMESTAMP, PRIMARY KEY(id) ); ``` and ``` CREATE TABLE users ( id...
Comparing './callrec_1.dump.sql' with './callrec_2.dump.sql' .... Exception in thread "main" java.lang.RuntimeException: Cannot find object '"SCHEMA_UPDATES"' for statement 'ALTER TABLE ONLY "SCHEMA_UPDATES" ADD CONSTRAINT "SCHEMA_UPDATES_pk" PRIMARY KEY (version);'. at cz.startnet.utils.pgdiff.parsers.AlterTableParser.parse(AlterTableParser.java:78) at cz.startnet.utils.pgdiff.loader.PgDumpLoader.loadDatabaseSchema(PgDumpLoader.java:179)...
If a table is added with int4range type with a default value, an error occurs: create table foo (f1 int4range default '[1,42)'::int4range not null); # java -jar /usr/share/java/apgdiff-2.4.jar /tmp/apgdiff1.sql /tmp/apgdiff2.sql...
