drawdb icon indicating copy to clipboard operation
drawdb copied to clipboard

[BUG] Postgres UNLOGGED tables not recognized on "Import from SQL"

Open kmoppel opened this issue 8 months ago • 1 comments

Describe the bug Postgres unlogged tables are a common optimization trick for transient steps in ETL/ELT jobs. A workaround is of course to remove the UNLOGGED part, but tedious.

Thus this DDL should work:

CREATE UNLOGGED TABLE t1 (
    id integer PRIMARY KEY,
    data text
);

To Reproduce Steps to reproduce the behavior:

  1. Go to 'Import from SQL'
  2. Select the above detailed schema file
  3. Click "Import"
  4. See error:

Image

kmoppel avatar Apr 09 '25 08:04 kmoppel

https://github.com/taozhi8833998/node-sql-parser/issues/2382

1ilit avatar Apr 09 '25 19:04 1ilit