PostgreSQL showing tables problem

Hi all,

I have a problem with PostgreSQL database connected on DataGrip. The connection is successful and I see every database on the server, but I can't see SCHEMA, TABLES, ... etc. in the databases. I can't see nothing below database level. I try synchronization many times. I'm using 'postgres' user. It's no error message to understand what is the problem.

Every other SQL server that I use is OK. (MySQL and MSSQL Server)

DataGrip version 2016.2 Build #DB-162.1122.5

PostgreSQL version 9.5.3

JDBC Driver - I try postgresql-9.4.1201 (standard driver downloaded from DataGrip) and try also postgresql-9.4.1209 (last driver downloaded from PostgreSQL site)

Screenshot here - https://gyazo.com/d1324f362384bededc8b7f13d065fc50

17 comments
Comment actions Permalink

I'm experiencing the same issue.

0
Comment actions Permalink

The screenshot is dead

0
Comment actions Permalink

I found what is the problem

Just for every database I change the URL in Data Sources

URL: jdbc:postgresql://**.**.**.**:5432/my_database

1
Comment actions Permalink

So, all is ok now, right?

 

 

0
Comment actions Permalink

Yes, it's right.

0
Comment actions Permalink

I have this same problem, I can connect but all i see is:

connectionName -> databaseName

I dont see the tables

please can anyone help?

If i use the same credentials on say Psequal, it connects fine

 

0
Comment actions Permalink

I got the same problem.

 

My env:

IntelliJ IDEA 2017.2
Build #IU-172.3317.76, built on July 15, 2017
JRE: 1.8.0_152-release-915-b5 amd64
JVM: OpenJDK 64-Bit Server VM by JetBrains s.r.o
Linux 4.8.0-58-generic

psql (9.5.7)

 

 

the error is 

 

```

[42725] org.postgresql.util.PSQLException: ERROR: function array_agg(bigint) is not unique
Indice : Could not choose a best candidate function. You might need to add explicit type casts.
Position : 255.
ERROR: function array_agg(bigint) is not unique
Indice : Could not choose a best candidate function. You might need to add explicit type casts.
Position : 255

```

1
Comment actions Permalink

I have the same problem connecting to PostgreSQL 9.6.x. It worked for a short while, but now I can't see the schema.

I can still execute commands to search and modify the databases, but the IDE does not see the schema and is unable to provide and  help writing commands.

This is very irritating. Everything works fine with SQL Server.

Datagrip is really excellent - apart from this issue.

0
Comment actions Permalink

I just updated DataGrip to 2017.3 built 5th December 2017 and I can now see my Postgresql schemas. Great!

0
Comment actions Permalink

Any update of this one ? still not working in IntelliJ neither in DataGrip.

Why ? :(

0
Comment actions Permalink

@Tony Chemit

Can I ask you for a screenshot? Did you try to choose schemas to be visible?

Also, the screenshot of Schemas in data source properties will be useful.

0
Comment actions Permalink

 

Try the following:

Go to your PostgreSQL database in "Data Sources and Drivers". On the options tab select "Introspect using JDBC metadata".

Does this help?

2
Comment actions Permalink

If it helps, it isn't normal anyway. For PostgreSQL, DataGrip MUST introspect without using JDBC metadata.

0
Comment actions Permalink

@Maxim

yes i check some schema

then I got this

Now I try to activate Introspect with JDBC metadata, and I got some success!

you can see I got some tables in my schema, but I still got an error. So @Maxim why DataGrip MUST not introspect with JDBC metadata as it seems to work (for now...)

Works also in IntellIJ :D 

0
Comment actions Permalink

@Chris yes it helps a lot, thanks.

0
Comment actions Permalink

@Tony, a huge thanks for the report! We'll fix it in the upcoming bug-fix update.

1
Comment actions Permalink

I'm having the same issue. I use the Postgres connection to access my redshift db. The tables were there as recently as a couple of days ago that I remember. You can also see that the tables are fine for my mysql connections. When I restart the program/connection, the arrows (for expanding table lists) appear and then disappear.

I'm on version 2016.3 and selected "Introspect using JDBC metadata" but that didn't help.

0

Please sign in to leave a comment.