PostgreSQL constraint options aren't recognized

Ask the Community
1

The line CONSTRAINT Findings_ak_id_typeid UNIQUE (findings_id, findings_type_id) NOT DEFERRABLE INITIALLY IMMEDIATE, returns the error:

(44:77) Expected " ", “,”, “\n”, “\r\n”, “\t”, or comment but “N” found.

Removing NOT DEFERRABLE INITIALLY IMMEDIATE makes the line pass syntax. These are valid options on a constraint and should be supported.

2

Hi @artis3n, i’m Khoa from dbdiagram team, thank you for your feedback on the dbdiagram.
We’ re currently working on updating syntax of PostgreSQL and will notice you as soon as possible.