drawdb icon indicating copy to clipboard operation
drawdb copied to clipboard

[BUG] error importing postgresql sql script

Open carlosmascarenhas opened this issue 1 year ago • 3 comments

Describe the bug When I try to import an SQL script generated by drawDB itself that has an auto-increment field, the following error is returned: image

Apparently it has to do with the PR #255

To Reproduce try to import this sql script that was generated by drawDB itself:

CREATE TABLE "test" (
	"id" INTEGER NOT NULL UNIQUE GENERATED BY DEFAULT AS IDENTITY,
	PRIMARY KEY("id")
);

carlosmascarenhas avatar Nov 04 '24 20:11 carlosmascarenhas

#255 deals with exports. The parser fails on 'generated'. I'll report it if I haven't already

1ilit avatar Nov 05 '24 00:11 1ilit

@1ilit hey can i work on this if this issue is still open?

Jal-GG avatar Mar 17 '25 07:03 Jal-GG

@Jal-GG yes but check if it's already fixed, the issue is in node-sql-parser not in drawdb

1ilit avatar Mar 17 '25 07:03 1ilit