1. hoshea hashub
  2. PowerBuilder
  3. Wednesday, 11 October 2023 03:38 AM UTC

Windows 10
PB Version 6.5.1
Postgres 9.2
psql-ODBC 9.02.01 Connection

 


Hi,


When I connect to postgres database with PB and create a Datawindow, the schema will be automatically generated before the table name.

 

I found that when I created a new Datawindow, the schema was already in it.

I tried to set PBCatalogOwner, but the Datawindow still has a schema.

 

When I delete the schema manually, the DBname in ROWS -> ColumnSpecifications will have no table name.

 

I can manually set search_path in the database or odbc to specify it. Why is the schema automatically added in PB?

How can I make PB not generate schema, modify PB settings or ODBC configuration, Or in other ways?

 

Thanks!

 

hoshea hashub Accepted Answer Pending Moderation
  1. Friday, 10 November 2023 07:10 AM UTC
  2. PowerBuilder
  3. # 1

Hi,

All I know is that Postgresql was not supported in pb 6.5.1

regards

Thank you for your reply.

I now put the schema name in front of all the tables.

Comment
There are no comments made yet.
Miguel Leeuwe Accepted Answer Pending Moderation
  1. Wednesday, 11 October 2023 11:25 AM UTC
  2. PowerBuilder
  3. # 2

Hi,

All I know is that Postgresql was not supported in pb 6.5.1

regards

Comment
  1. Andreas Mykonios
  2. Friday, 10 November 2023 13:40 PM UTC
That's the only issue? Neither Powerbuilder is supported. :-)
  1. Helpful 1
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.