lukemurray / data-atom

Query and manage data sources from Atom
MIT License
152 stars 36 forks source link

incorrect database information displayed -postgresql #198

Open cmhatche23 opened 3 years ago

cmhatche23 commented 3 years ago

Hi,

I'm able to connect to a postgresql database using data-atom, and successfully run queries, but when toggling the database information, it doesn't seem to understand which database i'm connected to.

The connection/session itself, postgres@localhost, has two databases. Despite being able to run queries on the database that actually contains tables ('leetcode'), the data information display incorrectly shows me being only connected to 'postgres' (aka the default administrative connection database). And FYI, the 'postgres' database does not contain data, so clicking on the arrow next to the database in the 'database info' menu does not show any tables.

This is the structure of the session seen using DataGrip:

Screen Shot 2021-04-04 at 7 23 11 PM

Compared to Atom:

Screen Shot 2021-04-04 at 7 27 57 PM

To be clear, these are identical connections, with discrepant information displayed in the panes.

I double-checked the connection information by going to: 'Packages' > 'Data Atom' > 'edit connections'

and the database connection information is correctly entered. I'm able to run queries as if I'm connected to the 'leetcode' database, so i know i'm connected. The database info pane just doesn't correctly display the active database (and table structure) information based on what I'm actually connected to.