Trouble Browsing POSTGRESQL Database

This forum can be browsed by the general public. Posting is limited to current SAPIEN license holders with active maintenance and does not offer a response time guarantee.
Forum rules
DO NOT POST LICENSE NUMBERS, ACTIVATION KEYS OR ANY OTHER LICENSING INFORMATION IN THIS FORUM.
Only the original author and our tech personnel can reply to a topic that is created in this forum. If you find a topic that relates to an issue you are having, please create a new topic and reference the other in your post.

Any code longer than three lines should be added as code using the 'Select Code' dropdown menu or attached as a file.
This topic is 4 years and 2 months old and has exceeded the time allowed for comments. Please begin a new topic or use the search feature to find a similar but newer topic.
nate@thep4x.com
Posts: 3
Last visit: Thu Feb 20, 2020 4:47 pm

Trouble Browsing POSTGRESQL Database

Post by nate@thep4x.com »

Product, version and build: 5.6.167
32 or 64 bit version of product: 64
Operating system: Windows 10 Pro
32 or 64 bit OS: 64

I’m trying to browse a PostgreSQL database that I can connect to without any trouble outside of Powershell Studio but the database in the browser keeps looking like it’s trying to load/refresh and never goes any further than that.
Screenshot.PNG
Screenshot.PNG (14.62 KiB) Viewed 2600 times
User avatar
mxtrinidad
Posts: 399
Last visit: Tue May 16, 2023 6:52 am

Re: Trouble Browsing POSTGRESQL Database

Post by mxtrinidad »

Thanks for reporting the issue.

Our team will be investigating and we'll get back to you soon.
User avatar
mxtrinidad
Posts: 399
Last visit: Tue May 16, 2023 6:52 am

Re: Trouble Browsing POSTGRESQL Database

Post by mxtrinidad »

Can you please provide a screenshot of your ODBC connection?
This will help us in troubleshooting the issue you're experiencing.
User avatar
mxtrinidad
Posts: 399
Last visit: Tue May 16, 2023 6:52 am

Re: Trouble Browsing POSTGRESQL Database

Post by mxtrinidad »

During our investigation, it seems the issue is related to some kind of permission issue or the Object Browser only displays data elements only.
It works with a created User Database, and in Public you need to have something define a table in order for the browser to work.

The Database Object Browser it's not to substitute the Postgres Admin tool but we need to understand what would you like to display.
Postrges_01_2019-10-09_15-34-47.png
Postrges_01_2019-10-09_15-34-47.png (77.38 KiB) Viewed 2572 times
nate@thep4x.com
Posts: 3
Last visit: Thu Feb 20, 2020 4:47 pm

Re: Trouble Browsing POSTGRESQL Database

Post by nate@thep4x.com »

I see what you’re saying. It’s looking for a table that doesn’t exist effectively.
User avatar
brittneyr
Site Admin
Posts: 1654
Last visit: Wed Mar 27, 2024 1:54 pm
Answers: 39
Been upvoted: 30 times

Re: Trouble Browsing POSTGRESQL Database

Post by brittneyr »

Please try build 5.7.172 and let me know this problem is still occurring.
Brittney
SAPIEN Technologies, Inc.
This topic is 4 years and 2 months old and has exceeded the time allowed for comments. Please begin a new topic or use the search feature to find a similar but newer topic.