DataGrip Build #DB-223.7571.180/problems using virtual columns and virtual views
Answered
Hello
I am working with a datasource pointing on a Postgresql 14 database.
I have created virtual columns and virtual views but I can't delete them (the command "drop" in the menu is disabled)...
Is there a solution ?
Thank you.
Please sign in to leave a comment.
It will be fixed in the next versions in the scope of https://youtrack.jetbrains.com/issue/DBE-16816/No-way-to-drop-virtual-views-and-virtual-FK
For now, it is needed to remove the appropriate file for this view:
Thank you Konstantin.
...And for virtual columns ?
Best regards.
...I have tried this but the virtual column remains !
I'll wait for the next version...
Thank you.
Hello Konstantin,
Thank you so much to JetBrains for being so quick with the update. But... now, it's the popup menu "Modify visual view" command that doesn't work anymore... ;)
Best regards.
> "Modify visual view"
What do you mean? Could you share a screenshot?
Well, the popup menu option "Modify virtual view..." (Ctrl + F6) is activated but the window for editing the view does not open. The same problem with the Ctrl + F6 keyboard shortcut.
In fact, one can open a virtual view but, when using "Go to DDL" command, it shows :
Looks like there is an exception preventing dialog from being shown.
Please share the log (Help | Collect Logs and Diagnostic Data) via uploads.jetbrains.com and share the upload id.
Hello Konstantin
Here is the upload ID : 2022_12_13_26MENdzn3nNSfzJ5t4L6mY
Best regards.
Submitted bug request to investigate this further:
https://youtrack.jetbrains.com/issue/DBE-17004/DbEditorModelController.getMatcher-must-not-return-null
Please follow it for updates.