"missing source code" when viewing PostgreSQL Stored Procedure
已完成
When I try to view a stored procedure in any of our PostgreSQL databases, I get the same results:
-- auto-generated definition
create function f_populate_recency(inbegintime timestamp(0), inendtime timestamp(0))
as
-- missing source code for f_populate_recency
;
This occurs in IntelliJ IDEA and in DataGrip. According to my understanding, I should be able to see the source code for stored procedures, based on what I read in this link: https://www.jetbrains.com/datagrip/features/dbobjects.html (see "Edit Source Code" )
请先登录再写评论。
Could you try to invoke "Database tools -> Forget cached schemas" action and try to sync you data source again?
Yes I've done that and it did not resolve the issue.
Still happening on 2018.3?
I can confirm that as of 2018.2.5 it shows me the stored procedures correctly so I'll report this RESOLVED. Thank you!
@565636992
This is not ok anyway! Can I ask you to drop a line to datagrip@jetbrains.com so that we can investigate the problem?
I am getting the similar issue in below datagrip version -
DataGrip 2024.1.3
Build #DB-241.17011.41, built on May 15, 2024
Runtime version: 17.0.11+1-b1207.23 amd64
VM: OpenJDK 64-Bit Server VM by JetBrains s.r.o.
Windows 10.0
GC: G1 Young Generation, G1 Old Generation
Memory: 4096M
Cores: 12
Registry:
ide.experimental.ui=true
It's a sybase db server which I am connecting. I can view the code for the stored procedures already present in the database.
But when I just copy the existing procedure and create a new one by giving it another name, it creates it but I cannot see any code within it as shown in the image earlier.
I did refreshed the schema multiple times and disconnected/connected again to the server but no luck.