[BUG] Importing SQL (PostgreSQL) with Foreign Key reference does cause a SyntaxError
Author: emschuCreated Oct 29, 2025Updated Aug 30, 2026
Describe the bug Importing the provided test SQL (in PostgreSQL dialect) does not work and fails with a false-positive SyntaxError. The given test SQL is valid in Postgres dialect.
To Reproduce Steps to reproduce the behavior:
- Open the application
- Click on "File" -> "Import from SQL"
- Import an .sql-file with the test content below
- See error: "SyntaxError [Ln 13, Col 1]: Expected "(", "--", ".", "/*", or [ \t\n\r] but ")" found."
Test SQL content:
ddl_test.sql ddl_test_extended.sql
create table test.table1
(
id uuid not null
primary key
);
create table test.table2
(
id uuid not null
primary key,
ref_id uuid
references table1
);Expected behavior The import of the SQL file should work.
Screenshots
Desktop (please complete the following information):
- OS: Windows
- Browser Chrome
Additional context The second test file is slightly extended (one more column) and results in a different Syntax Error:
SyntaxError [Ln 12, Col 26]: Expected "(", "--", ".", "/*", [ \t\n\r], or [A-Za-z0-9_\-$一-龥À-ſ] but "," found.Source: drawdb-io/drawdb