List of routines not up to date
Hi,
I am quite new to DataGrip and I have used so far some tools from the competitors or some simple web based interfaces.
I currently work mostly with Postgresql 10.5 but I am working with most major RDBMS for the last 20 years.
Here is my issue, I work on a Windows 10 workstation on which there is an Oracle Virtualbox VM with Linux CentOS 7.5 and Postgresql 10.5 running and listening on port 5432. The VM is configured as "host only" network with an IP address in the range 192.168.56.102.
I have made some modifications to the database (in a particular function in a particular schema). The modification includes a change of name of the function.
Everything seems ok apart from the fact that DataGrip does not seem to take the changes into account. I still see the old procedure name and not the new one.
I have tried pretty much everything (restarting DataGrip, clearing the cache, disconnecting, reconnecting, synchronizing... ) and so on but I still do not see the correct list of procedures in my schema.
To confirm that everything is OK I have checked the objects with another tool (phpPgAdmin) and everything is as expected there.
Could you explain me why I do not see the list of actual objects updated as expected?
Please sign in to leave a comment.
> I have made some modifications to the database (in a particular function in a particular schema)
Did you make these modifications using another tool?
Try to invoke "Forget cached schemas..." action to verify you'll see changes.
Looks like there is an issue https://youtrack.jetbrains.com/issue/DBE-6185