Object explorer disappear when querying database table (version 9.0)

[pentolone]

I moved to version 9 and I see that Object explorer disappear when querying tables.

Why?

Furthermore, when I reopen Object explorer I loose the tab with the query result.

Is there any chance to make it work as in the previous version?

[akshay-joshi]

Hi @pentolone

The Object Explorer is no longer disappearing because it's part of a new "Workspace" layout. In this layout, the Query Tool, PSQL, and Schema Diff each have their dedicated workspaces, and the respective tab opens in the appropriate workspace. You can switch between workspaces using the toolbar on the left.

If you prefer the classic layout, you can revert to it by going to Preferences > Miscellaneous > User Interface > Layout, and selecting Classic.

[pentolone]

Thanks, I am rolling back to 8.14

[adityatoshniwal]

Thanks, I am rolling back to 8.14

You don't need to rollback to older version. You just need to change the preference as mentioned in above comment. Preferences > Miscellaneous > User Interface > Layout, and selecting Classic.

[pentolone]

The latest updates were against user NOT required features. See my open issues. Regards, Luca

…

On Fri, Feb 7, 2025 at 11:03 AM Aditya Toshniwal ***@***.***> wrote: Thanks, I am rolling back to 8.14 You don't need to rollback to older version. You just need to change the preference as mentioned in above comment. Preferences > Miscellaneous > User Interface > Layout, and selecting Classic. — Reply to this email directly, view it on GitHub <#8426 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AJMLUME2FDKMRSFZISXR3432OSAF3AVCNFSM6AAAAABWVLL7EGVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDMNBSGQ3TOOBQGE> . You are receiving this because you were mentioned.Message ID: ***@***.***>

-- Luca Romano ***@***.*** --------------------------------------- Have fun!

[enricvivgar]

Thanks, I am rolling back to 8.14

You don't need to rollback to older version. You just need to change the preference as mentioned in above comment. Preferences > Miscellaneous > User Interface > Layout, and selecting Classic.

What is the point of not allowing to keep the Object Explorer view when writing pl/pgSQL code? I keep 9.0 flavour but I don't know where is the win here vs 8.14

[dericke]

Thanks @akshay-joshi for showing where to find the setting to go back to classic interface. I hope I am being constructive when I say that this new default layout was an unpleasant surprise when upgrading to v9, as being able to refer to my database objects while I am writing a query is a pretty fundamental feature for a database browser. I see now that the changelog advertises the new workspaces as "distraction-free", but I personally very much want to be "distracted" by the names of my tables and columns while writing queries.

Hopefully there are users who find the new interface useful, but I think the change, and the means of undoing it, could've been communicated better in the pgadmin4 interface itself. If it's relevant, I update through winget and may have missed a message about the change that was visible in other channels.

[seidlmic]

Same experience. Be able to see DB objects while writing SQL fundamental feature. Switched back to Classic view. May be there is some future idea why there is Workspace layout?

[Kalabint]

Landed within 2 minutes since updating here...

Same feedback as the people above and before. What I like to do is have the Object Explorer open at the same time I'm writing a query. With this, I have all the relevant info I need at hand, without needing to change tabs every time I want to look something up. I can't remember the whole DB structure I use, so for me the Object Explorer is a helpful guide and not a distraction.

Otherwise great tool!

[akshay-joshi]

@dericke, @seidlmic and @Kalabint

Based on feedback from some users regarding the new Workspace layout, we've made a few improvements to the logic. With these changes, the Query Tool and PSQL tabs will now open in the same active workspace where the action is initiated.

For example:

1. If you're currently working in the default workspace with the Tree view and you open the Query Tool/View/Edit Data or PSQL, it will open within the same workspace.
2. Similarly, if any action is triggered from the Welcome page for the Query Tool or PSQL, the respective tab will open in the same active workspace.

Additionally, we've introduced a new preference setting: "Open the Query Tool/PSQL in their respective workspaces". By default, this setting is False. If set to True, it will behave like the v9.0 release, where the Query Tool, PSQL, and Schema Diff tabs will open in their respective workspaces when the Workspace layout is used.

This update will provide a more streamlined experience for all users. These changes will be available starting with the v9.1 release scheduled for March 13th. However, if you'd like to try them earlier, you can install the nightly build.

[dericke]

Thank you for the update! It's always gratifying to know when feedback is heard and incorporated.

[mike-niemand]

Classic works fine. :)