drawdb icon indicating copy to clipboard operation
drawdb copied to clipboard

[BUG]Some keywords that are not recognized when importing SQL source code (PG).

Open mjmjmmmjjj opened this issue 5 months ago • 2 comments

SQL Import Issues When importing the provided SQL source code via the menu, two issues were encountered:

Unrecognized Auto-Incrementing Sequence: The GENERATED BY DEFAULT AS IDENTITY clause for the auto-incrementing sequence was not recognized.

Unidentifiable Enum Types: The enumeration types, such as ENUM_LOGS_ENTRY_CATEGORY, could not be created, leading to them being unrecognized.

CREATE TABLE "t_logs" (

"log_id" INTEGER NOT NULL UNIQUE GENERATED BY DEFAULT AS IDENTITY,

"pat_id" VARCHAR(50) NOT NULL,

"entry_category" ENUM_LOGS_ENTRY_CATEGORY NOT NULL,

"operation_type" ENUM_LOGS_OPER_TYPE NOT NULL,

"entry_count" INTEGER NOT NULL,

"created_at" TIMESTAMP NOT NULL DEFAULT NOW(),

PRIMARY KEY("log_id")

);

mjmjmmmjjj avatar Jul 26 '25 02:07 mjmjmmmjjj

can you also add the definitions of the enums that didnt get created

1ilit avatar Jul 29 '25 18:07 1ilit

I would like to take this issue is it available to work on?

jessekoester avatar Oct 04 '25 01:10 jessekoester