apgdiff

apgdiff copied to clipboard

when your new crebas script contains new materialized views with indexes, the result of diff contains the materialized views but not the associated indexes.

lilletech

Cannot parse string: ALTER TABLE ONLY public.mytable_partitionned ATTACH PARTITION public.mytable_2013_t1 FOR VALUES IN (...)

4

Hello, I'm trying to use apgdiff v2.7.0 to compare 2 dumps generated with pg_dump from PostgreSQL 10. One of the tables is partitionned by values. apgdiff throw this exception :...

maltebrun

Unsupported command at position 30 'ATTACH PARTITION raw' -- apgdiff version 2.7.0

1

Some issues with version 2.7.0 Exception in thread "main" cz.startnet.utils.pgdiff.parsers.ParserException: Cannot parse string: ALTER TABLE ONLY raw.aiw_hub ATTACH PARTITION raw.aiw_hub_am FOR VALUES IN ('AM'); Unsupported command at position 30 'ATTACH...

gintaraskuc

Partition by range not supported in 2.6.0

5

First of all, I want to thank you for your efforts on this particular utility. I have a fairly complex schema that I'm trying to compare by environments, and I...

jayverizon

Is there a way to force quotes around column names? It looks like there used to be an option to do this in a much older version, I'm sure why...

proffparadox

I have two dumps, one with a `CREATE CAST` statement and one without it. apgdiff 2.7.0 doesn't notice the difference.

aditsu

Cannot parse string: ALTER TABLE public.xxxx ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY

2

Met this exception while trying to compare two PostgreSQL dumps exported using pg_dump from IntelliJ Exception in thread "main" cz.startnet.utils.pgdiff.parsers.ParserException: Cannot parse string: ALTER TABLE public.agents ALTER COLUMN id ADD...

jometho

Reserved keywords in diff causing issues

1

It _appears_ that quoted reserved keywords used as column names aren't handled properly by apgdiff: ``` Exception in thread "main" cz.startnet.utils.pgdiff.parsers.ParserException: Cannot find column '"time"' in table 'transaction' ``` This...

syphernl

Update the release artifact in the official site

1

I see the download page on the official site is still with 2.4, any timeline of updating it? https://www.apgdiff.com/download.php --- relates to #284

chenrui333

add support for parsing PARTITIONED BY LIST statements in CREATE TABLE

2

Unsupported command at position 396 'PARTITION BY LIST (f' at cz.startnet.utils.pgdiff.parsers.Parser.throwUnsupportedCommand(Parser.java:390) at cz.startnet.utils.pgdiff.parsers.CreateTableParser.parse(CreateTableParser.java:84) at cz.startnet.utils.pgdiff.loader.PgDumpLoader.loadDatabaseSchema(PgDumpLoader.java:178) 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)

saswata248