"missing source code" for PostgreSQL Stored Procedure

Answered

New to Data Grip. Connected to a redshift instance. I can see routines, but no details on them. They look like this:

-- auto-generated definition
create
procedure logs$track_run(i_start_time_dt timestamp, i_end_time_dt timestamp, i_script_name varchar, i_row_count int8, i_comments varchar, i_object_name varchar)
as $$
begin
-- missing source code
end;
$$;


I tried Forced Refresh a few times. (database tools --> Forget Cached Schemas then Force Refresh)

DataGrip 2019.3
Build #DB-193.5233.139, built on December 2, 2019

 

9 comments
Comment actions Permalink

Kevincrussell,

Could you try to reproduce the issue with the latest DataGrip and dedicated Redshift JDBC driver?

0
Comment actions Permalink

Experiencing same issue with PostgreSQL and MSSQL. Oracle and Sybase are fine, source code getting correctly extracted.

DataGrip 2021.2

0
Comment actions Permalink

vasily chernov

I have the latest driver: ver 1.2.41.1065. 

I am running DataGrip version 2019.3 but cannot upgrade due to my organizations rules.

It seems from the comments by Dmitry it occurs in the latest version also.

0
Comment actions Permalink

Kevincrussell,

You've got issues with Redshift. So the only way for you to update to the latest DataGrip to use Redshift JDBC driver version 2.X

0
Comment actions Permalink

Dmitry B Goydin,

Could you provide more details?

Have you tried `Force Refresh`?

0
Comment actions Permalink

Hi vasily chernov,

Thank you for looking into this.

The issue was found to be with many of tables/procedures not being assigned to correct roles after database's migration from Sybase.
Our DBA is sorting this out now.
Apologies!

Best Regards,
Dmitry

0
Comment actions Permalink

Upgrading resolved the issue. I did try force refresh but that did not help.

Current version: 2021.2

Driver: Amazon Driver ver 2.0.0.5

1
Comment actions Permalink

Hi , 

I have the same issue with Redshift database as well.

I'm using Datagrip version 2021.2.1 and Redshift driver 2.0.0.5 ( latest stable).

But still I'm not able to see the view definitions.

Any suggestions or alternatives much appreciated.

 

Thank you

Santosh

0
Comment actions Permalink

Skesavar2491,

Could you provide a sample? Provide a screenshot?

0

Please sign in to leave a comment.