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

Plugin generates wrong DDL for views #515

Open
zsomborzsuffa opened this issue Feb 5, 2025 · 0 comments
Open

Plugin generates wrong DDL for views #515

zsomborzsuffa opened this issue Feb 5, 2025 · 0 comments

Comments

@zsomborzsuffa
Copy link

Describe the bug
When generating DDL for existing views, although in the database the views have different scripts the plugin generates for all views the same DDL. I cannot reproduce which DDL actually takes, I guess it is from the last view created.

To Reproduce
Steps to reproduce the behavior:

  1. Open the object tree and go to views in a database
  2. Right click on the view name
  3. Select Script as create

Expected behavior
The correct view script should be displayed with CREATE OR REPLACE VIEW ...

Desktop (please complete the following information):

  • OS: Windows 11

ADS (please complete the following information):
Version: 1.50.0 (system setup)
Commit: 49c73a84388731fec941dac8d938345ac16bd470
Date: 2024-11-17T22:41:05.327Z
VS Code: 1.82.0
Electron: 30.5.1
Chromium: 124.0.6367.243
Node.js: 20.16.0
V8: 12.4.254.20-electron.0
OS: Windows_NT x64 10.0.26100

ADS PostgresSQL etension version: 0.6.0
PostgreSQL version: PostgreSQL 17.2 (Debian 17.2-1.pgdg120+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14) 12.2.0, 64-bit

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