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 SUBSCRIPTION NUMBERS, LICENSE 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: 2
Joined: Wed Aug 21, 2019 4:45 am

Trouble Browsing POSTGRESQL Database

Post by nate@thep4x.com » Wed Oct 09, 2019 3:45 am

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

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

Re: Trouble Browsing POSTGRESQL Database

Post by mxtrinidad » Wed Oct 09, 2019 6:21 am

Thanks for reporting the issue.

Our team will be investigating and we'll get back to you soon.

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

Re: Trouble Browsing POSTGRESQL Database

Post by mxtrinidad » Wed Oct 09, 2019 11:08 am

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: 351
Joined: Sun Mar 03, 2013 12:42 pm

Re: Trouble Browsing POSTGRESQL Database

Post by mxtrinidad » Wed Oct 09, 2019 12:48 pm

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

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

Re: Trouble Browsing POSTGRESQL Database

Post by nate@thep4x.com » Thu Oct 10, 2019 6:50 pm

I see what you’re saying. It’s looking for a table that doesn’t exist effectively.