apgdiff

apgdiff copied to clipboard

Add support for FUNCTION in CREATE TRIGGER

2

alexander-smyslov

Add support for slony truncate triggers. Fix incorrect disable trigger parsing of quoted identifiers. Fix incorrect expectOptional implementation not adhering to documented behavior.

marcus-kempe

fix for null pointer exception

1

Hi, I'm having a null pointer exception in the case there is a create view in the destination schema and not in the starting one. This fixes it, but I'm...

marco44

Exception in thread "main" java.lang.NullPointerException at cz.startnet.utils.pgdiff.parsers.CreateRuleParser.parse(CreateRuleParser.java:74) at cz.startnet.utils.pgdiff.loader.PgDumpLoader.loadDatabaseSchema(PgDumpLoader.java:275) at cz.startnet.utils.pgdiff.loader.PgDumpLoader.loadDatabaseSchema(PgDumpLoader.java:311) at cz.startnet.utils.pgdiff.PgDiff.createDiff(PgDiff.java:35) at cz.startnet.utils.pgdiff.Main.main(Main.java:39) when rule was not in default schema (because of incorrect lookup).

marcus-kempe

apgdiff was failing on CREATE SCHEMA IF NOT EXISTS statement.

2

This change skips the IF NOT EXISTS part, as it is irrelevant for apgdiff.

mikko-ahonen

### What happened apgdiff said to drop the table in schemas that are identical. ```sql -- /tmp/schema-old.sql CREATE SCHEMA public; CREATE TABLE public.node (instance_id text); ``` ```bash java -jar releases/apgdiff-2.6.0.jar...

jschaf

I've installed latest version from homebrew, just to make a diff on two very simple schema dump. However it seems to terminate when it encounters an ``` ALTER TABLE public.my_mat_view...

hyperknot

Cannot parse string: COMMENT ON COLUMN

6

Apparently, form a comment in August 2018: Postgres changed the way that search path semantics are used in pg_dump in response to this: https://wiki.postgresql.org/wiki/A_Guide_to_CVE-2018-1058:_Protect_Your_Search_Path The affect took place earlier this...

garykuipers

When trying to get a diff between a big dump with data and a dump of schema only, the command hangs using 100% cpu. When comparing only schema dumps it...

kripper

COMMENT ON current_database() IS NULL <-- current_database() throws error

7

The current_database command in this context breaks. I simply remove this line from the generated output.

chadfurman