Failing to show new Postgres Tables in DataGrip
Answered
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.
Please sign in to leave a comment.
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.
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.
@Dennis Bauszus Hi,
In case it'll happen again it would be great if you attach IDE logs.
Thank you.
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
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)
Forgetting shown schemas helps.
Right mouse click on database in Database window -> Database Tools -> Force Refresh
Neither forgetting cached schemas nor force refresh fix it for me.
The tables show up in other db managers.
Edit: It was in a different schema. That's embarrassing 😂
The same for me. your product is crap.
Viacheslav Lushchinskiy please provide additional details or create a new report at https://youtrack.jetbrains.com/newIssue?project=DBE