Failing to show new Postgres Tables in DataGrip

I am having a problem with new tables not showing in DataGrip 2016.3.

I have a PostgreSQL connection to a Postgres 9.5 database with an PostGIS 2.2 extension.

I ran an expansive algorithm to create a new table over night, DataGrip being turned off. When I log-in in the morning the table has been created. I can use the table but I do not see the table in the treeview. The table will never show despite me trying to synchronize the database.

This has happened a few times now and I found that the only way to see the table is to remove the Database connection from DataGrip and then re-add the connection.

6 comments
Comment actions Permalink

Hi,

Could you specify DataGrip version you use?

Do you click Synchronize on your data source?

Do you have missing table in the same schema?

 

As a workaround, you can invoke Forget Schemas action on your data source.

Thank you.

1
Comment actions Permalink

The DataGrip build is #DB-163.7744.4.

I tried to synchronize the data source.

All tables are in the public schema (the missing table included).

This hasn't happened in the last week and I rebuild connection as I need to do some work on the missing table. Will update this post when this happens again.

0
Comment actions Permalink

@Dennis Bauszus Hi,

In case it'll happen again it would be great if you attach IDE logs.

Thank you.

0
Comment actions Permalink

Hi Vasily... This just happened again. I loaded a large dataset via the commandline tool (shp2pgsql) from my local machine to a PostGIS database. I am connected to that database via Datagrip and the tables never showed despite the loads being finished and me being able to query the tables through the command line.

I tested forget schemas and this did the trick. The tables show now in the public schema.

I am happy with that workaround. It only took me a few seconds to do and all is well.

Thanks. Dennis

 

0
Comment actions Permalink

Hello,

I'm experiencing the same issue with Goland:

GoLand 2018.2.2
Build #GO-182.4129.57, built on August 23, 2018
Licensed to KEH eCommerce, LLC / Aleksey Malov
Subscription is active until May 24, 2019
JRE: 1.8.0_152-release-1248-b8 x86_64
JVM: OpenJDK 64-Bit Server VM by JetBrains s.r.o
macOS 10.13.6

I have PostgreSQL 9.6 with Postgis extension,

I tried to synchronize the data source.

All tables are in the public schema (the missing table included).

I also tried to stop Goland and start it again but the tables are missing (although I can see them in the output of the next command)

SELECT * FROM pg_catalog.pg_tables;

Forgetting shown schemas helps.

0
Comment actions Permalink

Right mouse click on database in Database window -> Database Tools -> Force Refresh

0

Please sign in to leave a comment.