"missing source code" when viewing PostgreSQL Stored Procedure

Completed

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" )

 

0
5 comments

Could you try to invoke "Database tools -> Forget cached schemas" action and try to sync you data source again?

0

Yes I've done that and it did not resolve the issue.

0

Still happening on 2018.3?

 

0

I can confirm that as of 2018.2.5 it shows me the stored procedures correctly so I'll report this RESOLVED. Thank you!

0

@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?

0

Please sign in to leave a comment.