Skip to content

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

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Open
kmoppel opened this issue Apr 9, 2025 · 1 comment
Open

Comments

@kmoppel
Copy link

kmoppel commented Apr 9, 2025

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

@1ilit
Copy link
Member

1ilit commented Apr 9, 2025

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants