apgdiff
apgdiff copied to clipboard
fordfrog
Another PostgreSQL Diff Tool
We are encountering the following error comparing a db with a newer schema which one of it's indexes is renamed. ``` ERROR: cannot drop constraint Doctors_pkey on table "Advisors" because...
Suppose I have a table ENUM with 2 columns, ID and TEXT, used as a muster for "master tables". Suppose I add a table ENUM_whatever_TYPES: CREATE TABLE "ENUM_whatever_TYPES" () INHERITS...
I'm getting the following exception with apgdiff v2.4 in OSX: `Exception in thread "main" java.lang.NullPointerException at cz.startnet.utils.pgdiff.parsers.CreateTriggerParser.parse(CreateTriggerParser.java:105) at cz.startnet.utils.pgdiff.loader.PgDumpLoader.loadDatabaseSchema(PgDumpLoader.java:195) 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)`
I've been relying on --add-defaults to handle adding columns with not null constraints. It'll set a default value, then drop it later after setting the NOT NULL. This works fine,...
In one instance, it generated a alter table statement that added a composite primary key that one or more of the columns allowed null. This should print out an error/comment...
Exception in thread "main" java.lang.StringIndexOutOfBoundsException: String index out of range: 74
# Environment - apgdiff-2.4 - Windows 7 SP1 - java 1.7.0_02 ## Development server - PostgreSQL 9.1.8, compiled by Visual C++ build 1500, 64-bit ## Production server - PostgreSQL 9.1.13...
When comparing the following sequence from my live database: devel_np=# \d classifications_id_seq Sequence "public.classifications_id_seq" Column | Type | Value ---------------+---------+------------------------ sequence_name | name | classifications_id_seq last_value | bigint | 302...
Hi, Is it true, that apgdiff does not support partitions? I get two different errors when working with partitions (though it might be something else?): ``` Exception in thread "main"...
for some reason ``` foo varchar(200) check(foo '') ``` is considered a distinct type from ``` foo varchar(200) check (foo '') ``` (the space after check)
I've not tested in previous versions of PostgreSQL, but in version 9.2, an error is thrown if there are not quotes around the schema names in the search path. Version...