Yugabyte + Docker + Postgres ERROR : System column with id -3

Answered

Hello, I have an instance of Postgres running on a Docker machine created by Yugabyte. I'm getting this Error. I know that the message say it's not supported, but I tested others clients, and works normal, why such tool like DataGrip doesn't work?

 

10 comments
Comment actions Permalink

Could you email me vasily.chernov@jetbrains.com your IDE logs?

Also, specify your PostgreSQL server version. 

As a temporary workaround you can enable "Introspect using JDBC metadata" for your data source

1
Comment actions Permalink

Thanks Vasily,

That really helped. 

here is the link of the meu idea log:  https://drive.google.com/file/d/1Czkw4TaUysiapuP5NnSUp9mkyWbG88nY/view?usp=sharing

1
Comment actions Permalink

Getting the same error with Yugabyte, the workaround helps, but not obvious.

1
Comment actions Permalink

Yes, it's not obvious since there is no pure support for Yugabyte solutions and Yugabyte is not pure PostgreSQL

 

1
Comment actions Permalink

Hi, I am using Datagrip 2021.2.4 which doesn't have that `Introspect using JDBC metadata` option. Because of this, I got the same error as the OP.

How can I solve this issue with DataGrip 2021.2.4? Where can I enable `Introspect using JDBC metadata`?

Thanks!

0
Comment actions Permalink

this option moved to Advanced tab.

0
Comment actions Permalink

Hi Yuriy, thanks for your reply! I did try to find it under Advanced tab. However there is no (exact) match for "Introspect using JDBC metadata".  

Maybe I miss something? Is there a new way to configure it? Could you help point out where this option is located? Maybe a screenshot would help. 

Thanks!

0
Comment actions Permalink

 which database do you work with? why do you need this option?

here it is:

1
Comment actions Permalink

Thanks very much, now I am able to connect to the database. (I just reinstall it and was able to find that option. Not sure why the first time I didn't see this...)

The database I connect to is YugabyteDB. I think I must use this option since YugabyteDB does not use PostgreSQL’s system columns given that these functions are handled by the DocDB storage engine of YugabyteDB. This option makes DataGrip’s PostgreSQL connector use standard JDBC metadata as opposed to PostgreSQL specific metadata.

0
Comment actions Permalink

There is an issue about YugabyteDB in our tracker https://youtrack.jetbrains.com/issue/DBE-8524 . Follow for progress and leave comments there.

1

Please sign in to leave a comment.