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.
nate@thep4x.com
Posts: 3
Meble kuchenne na zamówienie - na wymiar - Wrocław
Joined: Wed Aug 21, 2019 4:45 am

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 1353 times

User avatar
mxtrinidad
Site Admin
Posts: 399
Joined: Sun Mar 03, 2013 12:42 pm

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
Site Admin
Posts: 399
Joined: Sun Mar 03, 2013 12:42 pm

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
Site Admin
Posts: 399
Joined: Sun Mar 03, 2013 12:42 pm

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 1325 times

nate@thep4x.com
Posts: 3
Joined: Wed Aug 21, 2019 4:45 am

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: 423
Joined: Thu Jun 01, 2017 7:20 am

Re: Trouble Browsing POSTGRESQL Database

Post by brittneyr »

Please try build 5.7.172 and let me know this problem is still occurring.
Brittney Ryn
SAPIEN Technologies, Inc.