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

psqldef: parser fails with EXCLUDE constraint #473

Open
2 tasks
ktogo opened this issue Dec 27, 2023 · 0 comments · May be fixed by #528
Open
2 tasks

psqldef: parser fails with EXCLUDE constraint #473

ktogo opened this issue Dec 27, 2023 · 0 comments · May be fixed by #528
Labels
psqldef Bugs or feature requests related to PostgreSQL

Comments

@ktogo
Copy link

ktogo commented Dec 27, 2023

Platform

  • OS: Confirmed on MacOS
  • RDBMS: PostgreSQL
  • Version: Confirmed on v0.16.13

--export output

CREATE TABLE "public"."exclude_example" (
    "id" serial NOT NULL
);

CREATE INDEX exclude_example_id_excl ON public.exclude_example USING btree (id);

Input SQL

CREATE TABLE exclude_example (
  id SERIAL NOT NULL,
  EXCLUDE (id WITH =)
);

Current output

found syntax error when parsing DDL "CREATE TABLE exclude_example (
  id SERIAL NOT NULL,
  EXCLUDE (id WITH =)
)": syntax error at position 65

Expected output

  • Parser should not fail
  • Exported SQL should be equal to the input SQL
@k0kubun k0kubun added the psqldef Bugs or feature requests related to PostgreSQL label Dec 27, 2023
@sanemat sanemat linked a pull request May 26, 2024 that will close this issue
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
psqldef Bugs or feature requests related to PostgreSQL
Projects
None yet
Development

Successfully merging a pull request may close this issue.

2 participants