DataGrip Build #DB-223.7571.180/problems using virtual columns and virtual views

已回答

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.

评论操作 固定链接

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: 

0
评论操作 固定链接

Thank you Konstantin.

...And for virtual columns ?

Best regards.

 

0
评论操作 固定链接

...I have tried this but the virtual column remains !
I'll wait for the next version...
Thank you.

0
评论操作 固定链接

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.

0
评论操作 固定链接

> "Modify visual view"

 

What do you mean? Could you share a screenshot? 

0
评论操作 固定链接

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 :

-- auto-generated definition
-- Unexpected: ImplantedVirtualObject
0
评论操作 固定链接

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. 

0
评论操作 固定链接

Hello Konstantin

Here is the upload ID : 2022_12_13_26MENdzn3nNSfzJ5t4L6mY

Best regards.

0

请先登录再写评论。