You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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
CREATETABLEpublic.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
);
ALTERTABLE ONLY public.employee
ADD CONSTRAINT employee_unique_en UNIQUE NULLS NOT DISTINCT (initials, name_en, surname_en);
ALTERTABLE ONLY public.employee
ADD CONSTRAINT employee_unique_ru UNIQUE NULLS NOT DISTINCT (initials, name, surname);
pg-mem version
2.8.1
The text was updated successfully, but these errors were encountered:
Describe the bug
Can't load database dump, that contains
NULLS NOT DISTINCT
constraint.To Reproduce
pg-mem version
2.8.1
The text was updated successfully, but these errors were encountered: