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鈥檒l occasionally send you account related emails.

Already on GitHub? Sign in to your account

Unsupported NULLS NOT DISTINCT from pg_pump #392

Open
AlexHromov10 opened this issue Mar 27, 2024 · 0 comments
Open

Unsupported NULLS NOT DISTINCT from pg_pump #392

AlexHromov10 opened this issue Mar 27, 2024 · 0 comments

Comments

@AlexHromov10
Copy link

Describe the bug

Can't load database dump, that contains NULLS NOT DISTINCT constraint.

馃拃 Syntax error at line 10 col 46:

 8
 9  ALTER TABLE ONLY public.employee
10      ADD CONSTRAINT employee_unique_ru UNIQUE NULLS NOT DISTINCT (initials, name, surname);;
                                                 ^
Unexpected word token: "nulls". Instead, I was expecting to see one of the following:

    - A "lparen" token

To Reproduce

CREATE TABLE public.employee (
    initials character varying(10),
    name character varying(127) NOT NULL,
    surname character varying(127) NOT NULL,
    name_en character varying NOT NULL,
    surname_en character varying NOT NULL
);

ALTER TABLE ONLY public.employee
    ADD CONSTRAINT employee_unique_en UNIQUE NULLS NOT DISTINCT (initials, name_en, surname_en);

ALTER TABLE ONLY public.employee
    ADD CONSTRAINT employee_unique_ru UNIQUE NULLS NOT DISTINCT (initials, name, surname);

pg-mem version

2.8.1

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

1 participant