" />

  1. ATK Gimmy Susan
  2. PowerBuilder
  3. Tuesday, 23 June 2020 08:49 AM UTC

good morning

I'm starting to work with PostgreSQL, but I'm having some difficulties.

It looks like an IDE problem.


Can anyone help me ?

I attach Print Screen

 

1) i see the tables

 

2) if i selecct a table i can't see the columns

 

3) if i use datawindow painter for build a datawindow i have no column.

 

4) If i use dbpainter for execure a sql, it works well.

 

 

Ecosystem:

- Windos 10 64bit

- PostgreSQL version 12.2 installed on server linux

- odbc 32bit 

- Powerbuilder 2019r2

 

Thanks in advance

Regreats

Gimmy

 

Accepted Answer
ATK Gimmy Susan Accepted Answer Pending Moderation
  1. Monday, 29 June 2020 16:14 PM UTC
  2. PowerBuilder
  3. # Permalink

Hi Chris

The problem is not with permissions, but with the version of the ODBC drivers.

It is not clear to me how the drivers are compatible with the server (odbc_version VS server_version); especially if there is a retro compatibility, but changing the version of the odbc drivers everything worked.

 

 

 

Comment
  1. Armeen Mazda @Appeon
  2. Monday, 29 June 2020 18:31 PM UTC
Thanks for sharing the solution!
  1. Helpful
  1. Chris Pollach @Appeon
  2. Monday, 29 June 2020 18:53 PM UTC
Hi Gimmy;

Yes, I had the same issue with PostGreSQL when I started with it. Seems like the default ODBC client install with the base DBMS install was OK for the PG "Console" app to work but not PB. I then had to separately download the ODBC driver pack for the PG version I just installed and then after that installation, the PB IDE and Apps were OK. Seems like a PG "packaging" / install issue to me.

Regards ... Chris
  1. Helpful
There are no comments made yet.
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Tuesday, 23 June 2020 14:53 PM UTC
  2. PowerBuilder
  3. # 1

Hi Gimmy;

  The most likely reason would be that the User ID that you are logging into the PostGreSQL database with does not have the proper Table / Column permissions. I get the same issue on my test systems until I either a) login in with a User ID that has DBO ( DB Owner) table access or b) grant the table / column permissions to my PB Developer user DB Login account.

HTH

Regards ... Chris

Comment
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.