apgdiff
apgdiff copied to clipboard
fordfrog
Another PostgreSQL Diff Tool
I have few sqls using domain.But there is no support of domain in apgdiff
The beginning of the script removes the constraint company_type_con which is: CHECK ((((((company_type = 'ltd'::text) OR (company_type = 'part'::text)) OR (company_type = 'sole'::text)) OR (company_type = 'charity'::text)) OR (company_type =...
Let's say I have the following constraint definition dump_1 ALTER TABLE "TableName" ADD CONSTRAINT "chk_range" CHECK (("Column1" = 2::numeric)); and on dump_2 I have ALTER TABLE "TableName" ADD CONSTRAINT "chk_range"...
There can be dependencies between VIEWs, FUNCTIONs and TABLEs, so they cannot be DROPped in certain orders. Although apgdiff generates the correct DROP commands, it doesn't order them to observe...
current when compare table, it's don't care about rule. i think it's worth for add. wdyt?
APGDiff Generated (B->A): /\* B _/ CREATE TRIGGER _role_if_modified_trg EXECUTE PROCEDURE audit.if_modified_func(); ... /_ A */ CREATE FUNCTION audit.if_modified_func() .... Should have arranged these as A->B
Seem either there is a bug somewhere in apgdiff, or I’m using it the wrong way as I’m getting the following error: `Exception in thread "main" cz.startnet.utils.pgdiff.parsers.ParserException: Cannot parse string:...
Please support CREATE CONSTRAINT TRIGGER. Here are two minimal sql files which show the missing feature: DB with CONSTRAINT TRIGGER: db.sql ``` sql CREATE TABLE foo_table ( id integer NOT...
It seems like altering column type is not suppoerted? ``` sql ALTER TABLE users ALTER COLUMN email TYPE VARCHAR(50) /* TYPE change - table: users original: VARCHAR(50) NOT NULL UNIQUE...
If the dump file contains COPY commands for data the following DDL command is ignored. In the following example the constraint ixlicensecode is ignored/skipped. If I remove "." then it...
