Datagrip won't update Postgres table schema
This has been an issue for me multiple times now. Trying to add a column to a table in datagrip and after executing the query, it just gets stuck on "Updating Database..." and never ends. I just updated to the most current version and updated my Postgres driver yesterday.
I've tried synchronizing the Postgres, my data source off of postgres, the database, the tables everything. Turned off auto commit, auto sync and still not working. No applications are interacting with the database either.
This is the query I'm trying to execute
ALTER TABLE public.tasks ADD subject_url VARCHAR(255) NULL;
Any solutions to fix this?
请先登录再写评论。
Hi,
Could you provide sample table DDL and add IDE logs concerning this issue?
Thank you.
I am having a similar issue with commits/submitting changes to Postgres. Table renaming wont push to the source. It shows the renamed tables in the Datagrip IDE, but after attempting to commit/submit the changes to the Source Postgress Database, nothing occurs.
Similarly there was a table created by Datagrip as a query, and that shows in the Source Postgress Database, but not in the Datagrip IDE even though that is where the SQL Statement was ran from.
I have tried "forgeting the Schema Cache" and have verified that the Database is not in read-only mode.
Respectfully Submitted,
@RIch Bair
Could you email me vasily.chernov@jetbrains.com IDE logs?
Could you provide step by step description to reproduce the issue?
Is there a possibility to record a screencast?
Recording No, but we could have a webex to show you what i am experiencing