Meaning of colors in Database view?
Answered
I am using the Database view in Rider attached to a Postgres database. The routines view lists all of my views in different colors - white, blue, red. I can't figure out what this is showing - I'm used to those colors being associated with source control status, but that's (unfortunately, ahem) not a thing for these routines. Any ideas?
Please sign in to leave a comment.
Hi William Iverson
Could you please check if colors are set for the Database view at Database > Right-click on a routine/view > Set Color
If that's not the case, please share a screenshot of the current behavior.
Here's a screenshot. Never used the Tools / Set Color... option. Below are screenshots of the view showing the different colors for the routines and the Set Color... dialog options.
Usually, this means that there are local changes in this routine while new sources come from the database. If you open you should see a warning message which offers some actions on this.
Yeah, that was my original thought (VCS). So, is it showing some kind of caching status? I'm seeing database introspection stuff coming through but the colors don't seem to change in a way that makes sense. For example, selecting Refresh doesn't seem to change anything.
FWIW these seem to mainly be a thing with the functions/routines/sprocs. Not seeing the colors on the regular table columns.
Try to submit the change on one mentioned routine to see if the color is not shown anymore.
Please check https://www.jetbrains.com/help/datagrip/2023.2/modifying-source-code-of-database-objects.html#colors-of-object-state for additional details about the colors.
It's kind of weird. I tried Refresh, Force Refresh, Forget All Cached Schema, Diagnostic Refresh and the colors (red, blue, white) all come back as before. No open sessions.
Try to re-add the Data Source as well. In case the issue persists open a request directly at YouTrack related to the Database Explorer at https://youtrack.jetbrains.com/newIssue?project=DBE so you can share additional info such as the IDE UI logs from Help | Collect Logs and Diagnostic Data