Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Partition by range not supported in 2.6.0 #261

Open
jayverizon opened this issue Oct 11, 2019 · 5 comments
Open

Partition by range not supported in 2.6.0 #261

jayverizon opened this issue Oct 11, 2019 · 5 comments

Comments

@jayverizon
Copy link

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 today downloaded 2.6.0, but it still complains about this syntax. Here is the specific error:

Unsupported command at position 1,250 'PARTITION BY RANGE ('
at cz.startnet.utils.pgdiff.parsers.Parser.throwUnsupportedCommand(Parse r.java:403)
at cz.startnet.utils.pgdiff.parsers.CreateTableParser.parse(CreateTableP arser.java:103)
at cz.startnet.utils.pgdiff.loader.PgDumpLoader.loadDatabaseSchema(PgDum pLoader.java:235)
at cz.startnet.utils.pgdiff.loader.PgDumpLoader.loadDatabaseSchema(PgDum pLoader.java:311)
at cz.startnet.utils.pgdiff.PgDiff.createDiff(PgDiff.java:35)
at cz.startnet.utils.pgdiff.Main.main(Main.java:39)

@jalissonmello
Copy link
Contributor

Can you help testing ? There is 2.6.1 jar on https://github.com/jalissonmello/apgdiff/tree/develop/releases

Maybe your problem was resolved.

@rokcarl
Copy link

rokcarl commented Nov 11, 2021

Had the same problem, downloaded 2.7.0 and the problem was gone, thank you.

I now have a different problem, but it's probably out of scope for this issue:

Exception in thread "main" cz.startnet.utils.pgdiff.parsers.ParserException: Cannot parse string: ALTER TABLE ONLY public.call_high_csat ATTACH PARTITION public.call_high_csat2017_01 FOR VALUES FROM ('2016-12-31 21:00:00+00') TO ('2017-01-31 21:00:00+00');
Unsupported command at position 40 'ATTACH PARTITION pub'
	at cz.startnet.utils.pgdiff.parsers.Parser.throwUnsupportedCommand(Parser.java:413)
	at cz.startnet.utils.pgdiff.parsers.AlterRelationParser.parse(AlterRelationParser.java:119)
	at cz.startnet.utils.pgdiff.loader.PgDumpLoader.loadDatabaseSchema(PgDumpLoader.java:248)
	at cz.startnet.utils.pgdiff.loader.PgDumpLoader.loadDatabaseSchema(PgDumpLoader.java:322)
	at cz.startnet.utils.pgdiff.PgDiff.createDiff(PgDiff.java:35)
	at cz.startnet.utils.pgdiff.Main.main(Main.java:39)

@mattatwork26
Copy link

@rokcarl did you find a work-around

@rokcarl
Copy link

rokcarl commented Jun 26, 2022

Not that I remember.

@kamal140415
Copy link

@rokcarl I am also getting the same issue. Can you please tell me if you find any solution or work around for this issue?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

5 participants