Diffing the same file results in `DROP TABLE` - Githubissues

fordfrog / apgdiff

Another PostgreSQL Diff Tool

http://www.apgdiff.com

MIT License

355 stars 138 forks source link

Diffing the same file results in `DROP TABLE` #264

Open jschaf opened 4 years ago

jschaf commented 4 years ago

What happened

apgdiff said to drop the table in schemas that are identical.

-- /tmp/schema-old.sql
CREATE SCHEMA public;
CREATE TABLE public.node (instance_id text);

java -jar releases/apgdiff-2.6.0.jar /tmp/schema-old.sql /tmp/schema-old.sql

SET search_path = public, pg_catalog;

DROP TABLE node;

Expected behavior

I expected an empty diff since the schemas are the same.

Info

Built from source at 735c05c.