Skip to content
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

Parsing Postgres 14 generated ddl results in error on ALTER statement #197

Open
tduval-unifylogic opened this issue Apr 24, 2023 · 0 comments

Comments

@tduval-unifylogic
Copy link

Describe the bug
Found this this morning, parsing a postgres 14 generated ddl (via backup) results in error:
ValueError: Found ALTER statement to not existed TABLE customers with SCHEMA public

To Reproduce
Steps to reproduce the behavior:
I added these steps so the output comes straight from postgres)

  1. Create database with the following Postgres generated DDL
  2. Right click on database, select backup (or just parse the attached file.
  3. Select file output location
  4. On General Tab, select output Plain
  5. On Data/Object Tab, select Only schema under 'Type of objects'
  6. Click Backup
  7. Run ddl-parser on file
  8. ValueError: Found ALTER statement to not existed TABLE customers with SCHEMA public

Expected behavior

Successful DDL Parse

Screenshots
n/a

Desktop (please complete the following information):

  • OS: mac os
  • Browser [e.g. chrome, safari]
  • Version postgres 14

Smartphone (please complete the following information):
n/a

Additional context
Add any other context about the problem here.

Expected behavior
Successful DDL Parse

Screenshots
n/a

Desktop (please complete the following information):

  • OS: [e.g. iOS]
  • Browser [e.g. chrome, safari]
  • Version [e.g. 22]

Smartphone (please complete the following information):

  • Device: [e.g. iPhone6]
  • OS: [e.g. iOS8.1]
  • Browser [e.g. stock browser, safari]
  • Version [e.g. 22]

Additional context
Add any other context about the problem here.

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

1 participant